APPS.AR_CHARGE_SCHEDULE_PKG dependencies on AR_CHARGE_SCHEDULES

Line 32: INSERT INTO AR_CHARGE_SCHEDULES

28: x_return_status IN OUT NOCOPY VARCHAR2)
29: IS
30: BEGIN
31: arp_standard.debug('Insert_schedule_Row +');
32: INSERT INTO AR_CHARGE_SCHEDULES
33: (SCHEDULE_ID ,
34: SCHEDULE_NAME ,
35: SCHEDULE_DESCRIPTION,
36: ATTRIBUTE_CATEGORY,

Line 120: UPDATE AR_CHARGE_SCHEDULES SET

116: x_return_status IN OUT NOCOPY VARCHAR2)
117: IS
118: BEGIN
119: arp_standard.debug('Insert_schedule_Row +');
120: UPDATE AR_CHARGE_SCHEDULES SET
121: SCHEDULE_DESCRIPTION = DECODE(P_SCHEDULE_DESCRIPTION,
122: FND_API.G_MISS_CHAR, NULL,
123: NULL , SCHEDULE_DESCRIPTION, P_SCHEDULE_DESCRIPTION ),
124: ATTRIBUTE_CATEGORY = DECODE(P_ATTRIBUTE_CATEGORY,

Line 698: FROM ar_charge_schedules

694: x_return_status IN OUT NOCOPY VARCHAR2)
695: IS
696: CURSOR c_schedule_id IS
697: SELECT NULL
698: FROM ar_charge_schedules
699: WHERE schedule_id = p_schedule_id;
700:
701: CURSOR c_aging_bucket IS
702: SELECT NULL

Line 746: FND_MESSAGE.SET_TOKEN('FK', 'ar charge schedules');

742: OPEN c_schedule_id;
743: FETCH c_schedule_id INTO l_c;
744: IF c_schedule_id%NOTFOUND THEN
745: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
746: FND_MESSAGE.SET_TOKEN('FK', 'ar charge schedules');
747: FND_MESSAGE.SET_TOKEN('COLUMN', 'schedule_id');
748: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_charge_schedules');
749: FND_MSG_PUB.ADD;
750: x_return_status := FND_API.G_RET_STS_ERROR;

Line 748: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_charge_schedules');

744: IF c_schedule_id%NOTFOUND THEN
745: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
746: FND_MESSAGE.SET_TOKEN('FK', 'ar charge schedules');
747: FND_MESSAGE.SET_TOKEN('COLUMN', 'schedule_id');
748: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_charge_schedules');
749: FND_MSG_PUB.ADD;
750: x_return_status := FND_API.G_RET_STS_ERROR;
751: END IF;
752: CLOSE c_schedule_id;

Line 1217: SELECT ar_charge_schedules_s.nextval

1213: x_msg_count OUT NOCOPY NUMBER,
1214: x_msg_data OUT NOCOPY VARCHAR2)
1215: IS
1216: CURSOR cu_schedule_id IS
1217: SELECT ar_charge_schedules_s.nextval
1218: FROM DUAL;
1219: l_schedule_id NUMBER;
1220: l_n VARCHAR2(10);
1221: BEGIN

Line 1355: FROM ar_charge_schedules

1351: ATTRIBUTE13 ,
1352: ATTRIBUTE14 ,
1353: ATTRIBUTE15 ,
1354: OBJECT_VERSION_NUMBER
1355: FROM ar_charge_schedules
1356: WHERE schedule_id = P_SCHEDULE_ID
1357: FOR UPDATE NOWAIT;
1358: l_rec c%ROWTYPE;
1359: BEGIN

Line 1398: fnd_message.set_token('RECORD', 'ar_charge_schedules');

1394: CLOSE c;
1395:
1396: IF l_rec.SCHEDULE_ID IS NULL THEN
1397: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1398: fnd_message.set_token('RECORD', 'ar_charge_schedules');
1399: fnd_message.set_token('VALUE',
1400: NVL(TO_CHAR(P_SCHEDULE_ID), 'null'));
1401: fnd_msg_pub.add;
1402: RAISE fnd_api.g_exc_error;

Line 1413: fnd_message.set_token('TABLE', 'ar_charge_schedules');

1409: l_rec.OBJECT_VERSION_NUMBER IS NOT NULL AND
1410: x_object_version_number = l_rec.OBJECT_VERSION_NUMBER))
1411: THEN
1412: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
1413: fnd_message.set_token('TABLE', 'ar_charge_schedules');
1414: fnd_msg_pub.add;
1415: RAISE fnd_api.g_exc_error;
1416: END IF;
1417: