APPS.GMS_AWARD_DIST_ENG dependencies on GMS_BC_PACKETS

Line 626: from gms_bc_packets

622: -- Debashis. Added exists and removed rownum.
623: select 1 into x_result_code from dual where exists (
624: select substr(NVL(result_code,'X'),1,1)
625: -- into x_result_code
626: from gms_bc_packets
627: where packet_id = X_packet_id
628: and substr(NVL(result_code,'X'),1,1) = 'F' );
629: -- and rownum < 2 ;
630:

Line 681: insert into gms_bc_packets ( packet_id,

677: x_doc_dist_id := valid_fp_tab(tab_index).document_distribution_id ;
678: END IF ;
679:
680:
681: insert into gms_bc_packets ( packet_id,
682: set_of_books_id,
683: je_source_name,
684: je_category_name,
685: actual_flag,

Line 747: gms_bc_packets_s.nextval

743: --tab_index,
744: 'N',
745: l_budget_version_id, ---bv.budget_version_id,
746: 'E',
747: gms_bc_packets_s.nextval
748: );
749:
750:
751: END loop;

Line 786: delete from gms_bc_packets

782: else
783: X_return := GET_RESULT_CODE ;
784: end if;
785:
786: delete from gms_bc_packets
787: where packet_id = X_packet_id;
788:
789: return X_return ;
790: