APPS.AR_CHARGE_SCHEDULE_PKG dependencies on AR_CHARGE_SCHEDULE_LINES

Line 431: INSERT INTO AR_charge_SCHEDULE_LINES

427: x_return_status IN OUT NOCOPY VARCHAR2)
428: IS
429: BEGIN
430: arp_standard.debug('Insert_Line_Row +');
431: INSERT INTO AR_charge_SCHEDULE_LINES
432: (SCHEDULE_LINE_ID ,
433: SCHEDULE_HEADER_ID ,
434: SCHEDULE_ID ,
435: AGING_BUCKET_ID ,

Line 528: UPDATE AR_charge_SCHEDULE_LINES SET

524: IS
525: BEGIN
526: arp_standard.debug('Update_Line_Row +');
527: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1;
528: UPDATE AR_charge_SCHEDULE_LINES SET
529: AMOUNT = DECODE(p_amount,
530: fnd_api.g_miss_num, NULL,
531: NULL ,AMOUNT,p_amount),
532: RATE = DECODE(p_rate,

Line 1008: FROM ar_charge_schedule_lines

1004: p_aging_bucket_id IN NUMBER,
1005: p_aging_bucket_line_id IN NUMBER)
1006: IS
1007: SELECT NULL
1008: FROM ar_charge_schedule_lines
1009: WHERE schedule_header_id = p_SCHEDULE_HEADER_ID
1010: AND aging_bucket_id = p_aging_bucket_id
1011: AND aging_bucket_line_id = p_aging_bucket_line_id;
1012:

Line 1103: arp_standard.debug(' A Record in ar_charge_schedule_lines exists with '||

1099: p_aging_bucket_id ,
1100: p_aging_bucket_line_id);
1101: FETCH ar_schedule_line_u2 INTO l_c;
1102: IF ar_schedule_line_u2%FOUND THEN
1103: arp_standard.debug(' A Record in ar_charge_schedule_lines exists with '||
1104: ' schedule_header_id - aging_bucket_id - aging_bucket_line_id');
1105: fnd_message.set_name('AR', 'AR_API_REC_COMB_EXISTS');
1106: fnd_message.set_token('COLUMN1', 'schedule_header_id');
1107: fnd_message.set_token('COLUMN2', 'aging_bucket_id');

Line 1835: SELECT ar_charge_schedule_lines_s.NEXTVAL

1831: x_msg_count OUT NOCOPY NUMBER,
1832: x_msg_data OUT NOCOPY VARCHAR2)
1833: IS
1834: CURSOR cu_line_id IS
1835: SELECT ar_charge_schedule_lines_s.NEXTVAL
1836: FROM dual;
1837: l_line_id NUMBER;
1838: BEGIN
1839: arp_standard.debug('create_schedule_line +');

Line 1982: FROM ar_charge_schedule_lines

1978: ATTRIBUTE13 ,
1979: ATTRIBUTE14 ,
1980: ATTRIBUTE15 ,
1981: OBJECT_VERSION_NUMBER
1982: FROM ar_charge_schedule_lines
1983: WHERE schedule_line_id = P_SCHEDULE_LINE_ID
1984: FOR UPDATE NOWAIT;
1985:
1986: l_rec c%ROWTYPE;

Line 2030: fnd_message.set_token('RECORD', 'ar_charge_schedule_lines');

2026: CLOSE c;
2027:
2028: IF l_rec.SCHEDULE_line_ID IS NULL THEN
2029: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
2030: fnd_message.set_token('RECORD', 'ar_charge_schedule_lines');
2031: fnd_message.set_token('VALUE',
2032: NVL(TO_CHAR(P_SCHEDULE_line_ID), 'null'));
2033: fnd_msg_pub.add;
2034: RAISE fnd_api.g_exc_error;

Line 2045: fnd_message.set_token('TABLE', 'ar_charge_schedule_lines');

2041: l_rec.OBJECT_VERSION_NUMBER IS NOT NULL AND
2042: x_object_version_number = l_rec.OBJECT_VERSION_NUMBER))
2043: THEN
2044: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
2045: fnd_message.set_token('TABLE', 'ar_charge_schedule_lines');
2046: fnd_msg_pub.add;
2047: RAISE fnd_api.g_exc_error;
2048: END IF;
2049: