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 1292: WHERE name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');

1288:
1289: cursor c_id is
1290: SELECT instance_status_id
1291: FROM csi_instance_statuses
1292: WHERE name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');
1293:
1294: r_id c_id%rowtype;
1295:
1296: CURSOR c_item_control (pc_item_id in number,

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

3058:
3059: cursor c_id is
3060: SELECT instance_status_id
3061: FROM csi_instance_statuses
3062: WHERE name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');
3063:
3064: r_id c_id%rowtype;
3065:
3066: -- Get the Transaction ID for the (-) quantity transaction and pass that