APPS.GMP_APS_DS_PULL dependencies on MSC_ST_RESOURCE_INSTANCE_REQS

Line 508: TYPE rec_serial_number IS TABLE OF msc_st_resource_instance_reqs.serial_number%TYPE

504: rec_inst_operation_seq_num number_idx_tbl;
505: rec_inst_department_id number_idx_tbl;
506: rec_inst_wip_entity_id number_idx_tbl;
507:
508: TYPE rec_serial_number IS TABLE OF msc_st_resource_instance_reqs.serial_number%TYPE
509: INDEX BY BINARY_INTEGER;
510: empty_inst_serial_number rec_serial_number ;
511: rec_inst_serial_number rec_serial_number;
512:

Line 2805: INSERT INTO msc_st_resource_instance_reqs (

2801: i := 1 ;
2802: log_message(rec_inst_organization_id.FIRST || ' *rir*' || rec_inst_organization_id.LAST );
2803: IF rec_inst_organization_id.FIRST > 0 THEN
2804: FORALL i IN rec_inst_organization_id.FIRST..rec_inst_organization_id.LAST
2805: INSERT INTO msc_st_resource_instance_reqs (
2806: supply_id,
2807: organization_id,
2808: sr_instance_id,
2809: resource_seq_num,