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 1219: SELECT ar_charge_schedules_s.nextval

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

Line 1357: FROM ar_charge_schedules

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

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

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

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

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