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,
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,
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