DBA Data[Home] [Help]

APPS.CSI_INV_INTERORG_PKG dependencies on FND_PROFILE

Line 102: WHERE name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');

98:
99: cursor c_id is
100: SELECT instance_status_id
101: FROM csi_instance_statuses
102: WHERE name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');
103:
104: r_id c_id%rowtype;
105:
106: CURSOR c_item_control (pc_item_id in number,

Line 1298: WHERE name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');

1294:
1295: cursor c_id is
1296: SELECT instance_status_id
1297: FROM csi_instance_statuses
1298: WHERE name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');
1299:
1300: r_id c_id%rowtype;
1301:
1302: CURSOR c_item_control (pc_item_id in number,

Line 3118: WHERE name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');

3114:
3115: cursor c_id is
3116: SELECT instance_status_id
3117: FROM csi_instance_statuses
3118: WHERE name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');
3119:
3120: r_id c_id%rowtype;
3121:
3122: -- Get the Transaction ID for the (-) quantity transaction and pass that