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 1010: FROM ar_charge_schedule_lines

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

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

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

Line 1837: SELECT ar_charge_schedule_lines_s.NEXTVAL

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

Line 1984: FROM ar_charge_schedule_lines

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

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

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

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

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