DBA Data[Home] [Help]

APPS.CSI_INV_ISO_PKG dependencies on FND_PROFILE

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

95:
96: cursor c_id is
97: SELECT instance_status_id
98: FROM csi_instance_statuses
99: WHERE name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');
100:
101: r_id c_id%rowtype;
102:
103: cursor c_inst (pc_instance_id in NUMBER) is

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

2099:
2100: cursor c_id is
2101: SELECT instance_status_id
2102: FROM csi_instance_statuses
2103: WHERE name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');
2104:
2105: r_id c_id%rowtype;
2106:
2107: CURSOR c_item_control (pc_item_id in number,

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

4101:
4102: cursor c_id is
4103: SELECT instance_status_id
4104: FROM csi_instance_statuses
4105: WHERE name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');
4106:
4107: r_id c_id%rowtype;
4108:
4109: -- Get the Transaction ID for the (-) quantity transaction and pass that