eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMS_FUNDS_CONTROL_PKG dependencies on GMS_BC_PACKETS

Line 10: TYPE t_set_of_books_id_type IS TABLE OF gms_bc_packets.set_of_books_id%type INDEX BY BINARY_INTEGER;

6: -- firing fundscheck hence existing logic is modified such that code which needs access
7: -- to AP/PO/REQ tables gets fired from main session and insert/update code gets fired in
8: -- autonomous mode. Added below variables for new logic.
9:
10: TYPE t_set_of_books_id_type IS TABLE OF gms_bc_packets.set_of_books_id%type INDEX BY BINARY_INTEGER;
11: TYPE t_je_source_name_type IS TABLE OF gms_bc_packets.je_source_name%type INDEX BY BINARY_INTEGER;
12: TYPE t_je_category_name_type IS TABLE OF gms_bc_packets.je_category_name%type INDEX BY BINARY_INTEGER;
13: TYPE t_actual_flag_type IS TABLE OF gms_bc_packets.actual_flag%type INDEX BY BINARY_INTEGER;
14: TYPE t_project_id_type IS TABLE OF gms_bc_packets.project_id%type INDEX BY BINARY_INTEGER;

Line 11: TYPE t_je_source_name_type IS TABLE OF gms_bc_packets.je_source_name%type INDEX BY BINARY_INTEGER;

7: -- to AP/PO/REQ tables gets fired from main session and insert/update code gets fired in
8: -- autonomous mode. Added below variables for new logic.
9:
10: TYPE t_set_of_books_id_type IS TABLE OF gms_bc_packets.set_of_books_id%type INDEX BY BINARY_INTEGER;
11: TYPE t_je_source_name_type IS TABLE OF gms_bc_packets.je_source_name%type INDEX BY BINARY_INTEGER;
12: TYPE t_je_category_name_type IS TABLE OF gms_bc_packets.je_category_name%type INDEX BY BINARY_INTEGER;
13: TYPE t_actual_flag_type IS TABLE OF gms_bc_packets.actual_flag%type INDEX BY BINARY_INTEGER;
14: TYPE t_project_id_type IS TABLE OF gms_bc_packets.project_id%type INDEX BY BINARY_INTEGER;
15: TYPE t_task_id_type IS TABLE OF gms_bc_packets.task_id%type INDEX BY BINARY_INTEGER;

Line 12: TYPE t_je_category_name_type IS TABLE OF gms_bc_packets.je_category_name%type INDEX BY BINARY_INTEGER;

8: -- autonomous mode. Added below variables for new logic.
9:
10: TYPE t_set_of_books_id_type IS TABLE OF gms_bc_packets.set_of_books_id%type INDEX BY BINARY_INTEGER;
11: TYPE t_je_source_name_type IS TABLE OF gms_bc_packets.je_source_name%type INDEX BY BINARY_INTEGER;
12: TYPE t_je_category_name_type IS TABLE OF gms_bc_packets.je_category_name%type INDEX BY BINARY_INTEGER;
13: TYPE t_actual_flag_type IS TABLE OF gms_bc_packets.actual_flag%type INDEX BY BINARY_INTEGER;
14: TYPE t_project_id_type IS TABLE OF gms_bc_packets.project_id%type INDEX BY BINARY_INTEGER;
15: TYPE t_task_id_type IS TABLE OF gms_bc_packets.task_id%type INDEX BY BINARY_INTEGER;
16: TYPE t_award_id_type IS TABLE OF gms_bc_packets.award_id%type INDEX BY BINARY_INTEGER;

Line 13: TYPE t_actual_flag_type IS TABLE OF gms_bc_packets.actual_flag%type INDEX BY BINARY_INTEGER;

9:
10: TYPE t_set_of_books_id_type IS TABLE OF gms_bc_packets.set_of_books_id%type INDEX BY BINARY_INTEGER;
11: TYPE t_je_source_name_type IS TABLE OF gms_bc_packets.je_source_name%type INDEX BY BINARY_INTEGER;
12: TYPE t_je_category_name_type IS TABLE OF gms_bc_packets.je_category_name%type INDEX BY BINARY_INTEGER;
13: TYPE t_actual_flag_type IS TABLE OF gms_bc_packets.actual_flag%type INDEX BY BINARY_INTEGER;
14: TYPE t_project_id_type IS TABLE OF gms_bc_packets.project_id%type INDEX BY BINARY_INTEGER;
15: TYPE t_task_id_type IS TABLE OF gms_bc_packets.task_id%type INDEX BY BINARY_INTEGER;
16: TYPE t_award_id_type IS TABLE OF gms_bc_packets.award_id%type INDEX BY BINARY_INTEGER;
17: TYPE t_result_code_type IS TABLE OF gms_bc_packets.result_code%type INDEX BY BINARY_INTEGER;

Line 14: TYPE t_project_id_type IS TABLE OF gms_bc_packets.project_id%type INDEX BY BINARY_INTEGER;

10: TYPE t_set_of_books_id_type IS TABLE OF gms_bc_packets.set_of_books_id%type INDEX BY BINARY_INTEGER;
11: TYPE t_je_source_name_type IS TABLE OF gms_bc_packets.je_source_name%type INDEX BY BINARY_INTEGER;
12: TYPE t_je_category_name_type IS TABLE OF gms_bc_packets.je_category_name%type INDEX BY BINARY_INTEGER;
13: TYPE t_actual_flag_type IS TABLE OF gms_bc_packets.actual_flag%type INDEX BY BINARY_INTEGER;
14: TYPE t_project_id_type IS TABLE OF gms_bc_packets.project_id%type INDEX BY BINARY_INTEGER;
15: TYPE t_task_id_type IS TABLE OF gms_bc_packets.task_id%type INDEX BY BINARY_INTEGER;
16: TYPE t_award_id_type IS TABLE OF gms_bc_packets.award_id%type INDEX BY BINARY_INTEGER;
17: TYPE t_result_code_type IS TABLE OF gms_bc_packets.result_code%type INDEX BY BINARY_INTEGER;
18: TYPE t_entered_dr_type IS TABLE OF gms_bc_packets.entered_dr%type INDEX BY BINARY_INTEGER;

Line 15: TYPE t_task_id_type IS TABLE OF gms_bc_packets.task_id%type INDEX BY BINARY_INTEGER;

11: TYPE t_je_source_name_type IS TABLE OF gms_bc_packets.je_source_name%type INDEX BY BINARY_INTEGER;
12: TYPE t_je_category_name_type IS TABLE OF gms_bc_packets.je_category_name%type INDEX BY BINARY_INTEGER;
13: TYPE t_actual_flag_type IS TABLE OF gms_bc_packets.actual_flag%type INDEX BY BINARY_INTEGER;
14: TYPE t_project_id_type IS TABLE OF gms_bc_packets.project_id%type INDEX BY BINARY_INTEGER;
15: TYPE t_task_id_type IS TABLE OF gms_bc_packets.task_id%type INDEX BY BINARY_INTEGER;
16: TYPE t_award_id_type IS TABLE OF gms_bc_packets.award_id%type INDEX BY BINARY_INTEGER;
17: TYPE t_result_code_type IS TABLE OF gms_bc_packets.result_code%type INDEX BY BINARY_INTEGER;
18: TYPE t_entered_dr_type IS TABLE OF gms_bc_packets.entered_dr%type INDEX BY BINARY_INTEGER;
19: TYPE t_entered_cr_type IS TABLE OF gms_bc_packets.entered_cr%type INDEX BY BINARY_INTEGER;

Line 16: TYPE t_award_id_type IS TABLE OF gms_bc_packets.award_id%type INDEX BY BINARY_INTEGER;

12: TYPE t_je_category_name_type IS TABLE OF gms_bc_packets.je_category_name%type INDEX BY BINARY_INTEGER;
13: TYPE t_actual_flag_type IS TABLE OF gms_bc_packets.actual_flag%type INDEX BY BINARY_INTEGER;
14: TYPE t_project_id_type IS TABLE OF gms_bc_packets.project_id%type INDEX BY BINARY_INTEGER;
15: TYPE t_task_id_type IS TABLE OF gms_bc_packets.task_id%type INDEX BY BINARY_INTEGER;
16: TYPE t_award_id_type IS TABLE OF gms_bc_packets.award_id%type INDEX BY BINARY_INTEGER;
17: TYPE t_result_code_type IS TABLE OF gms_bc_packets.result_code%type INDEX BY BINARY_INTEGER;
18: TYPE t_entered_dr_type IS TABLE OF gms_bc_packets.entered_dr%type INDEX BY BINARY_INTEGER;
19: TYPE t_entered_cr_type IS TABLE OF gms_bc_packets.entered_cr%type INDEX BY BINARY_INTEGER;
20: TYPE t_etype_type IS TABLE OF gms_bc_packets.expenditure_type%type INDEX BY BINARY_INTEGER;

Line 17: TYPE t_result_code_type IS TABLE OF gms_bc_packets.result_code%type INDEX BY BINARY_INTEGER;

13: TYPE t_actual_flag_type IS TABLE OF gms_bc_packets.actual_flag%type INDEX BY BINARY_INTEGER;
14: TYPE t_project_id_type IS TABLE OF gms_bc_packets.project_id%type INDEX BY BINARY_INTEGER;
15: TYPE t_task_id_type IS TABLE OF gms_bc_packets.task_id%type INDEX BY BINARY_INTEGER;
16: TYPE t_award_id_type IS TABLE OF gms_bc_packets.award_id%type INDEX BY BINARY_INTEGER;
17: TYPE t_result_code_type IS TABLE OF gms_bc_packets.result_code%type INDEX BY BINARY_INTEGER;
18: TYPE t_entered_dr_type IS TABLE OF gms_bc_packets.entered_dr%type INDEX BY BINARY_INTEGER;
19: TYPE t_entered_cr_type IS TABLE OF gms_bc_packets.entered_cr%type INDEX BY BINARY_INTEGER;
20: TYPE t_etype_type IS TABLE OF gms_bc_packets.expenditure_type%type INDEX BY BINARY_INTEGER;
21: TYPE t_exp_org_id_type IS TABLE OF gms_bc_packets.expenditure_organization_id%type INDEX BY BINARY_INTEGER;

Line 18: TYPE t_entered_dr_type IS TABLE OF gms_bc_packets.entered_dr%type INDEX BY BINARY_INTEGER;

14: TYPE t_project_id_type IS TABLE OF gms_bc_packets.project_id%type INDEX BY BINARY_INTEGER;
15: TYPE t_task_id_type IS TABLE OF gms_bc_packets.task_id%type INDEX BY BINARY_INTEGER;
16: TYPE t_award_id_type IS TABLE OF gms_bc_packets.award_id%type INDEX BY BINARY_INTEGER;
17: TYPE t_result_code_type IS TABLE OF gms_bc_packets.result_code%type INDEX BY BINARY_INTEGER;
18: TYPE t_entered_dr_type IS TABLE OF gms_bc_packets.entered_dr%type INDEX BY BINARY_INTEGER;
19: TYPE t_entered_cr_type IS TABLE OF gms_bc_packets.entered_cr%type INDEX BY BINARY_INTEGER;
20: TYPE t_etype_type IS TABLE OF gms_bc_packets.expenditure_type%type INDEX BY BINARY_INTEGER;
21: TYPE t_exp_org_id_type IS TABLE OF gms_bc_packets.expenditure_organization_id%type INDEX BY BINARY_INTEGER;
22: TYPE t_exp_item_date_type IS TABLE OF gms_bc_packets.expenditure_item_date%type INDEX BY BINARY_INTEGER;

Line 19: TYPE t_entered_cr_type IS TABLE OF gms_bc_packets.entered_cr%type INDEX BY BINARY_INTEGER;

15: TYPE t_task_id_type IS TABLE OF gms_bc_packets.task_id%type INDEX BY BINARY_INTEGER;
16: TYPE t_award_id_type IS TABLE OF gms_bc_packets.award_id%type INDEX BY BINARY_INTEGER;
17: TYPE t_result_code_type IS TABLE OF gms_bc_packets.result_code%type INDEX BY BINARY_INTEGER;
18: TYPE t_entered_dr_type IS TABLE OF gms_bc_packets.entered_dr%type INDEX BY BINARY_INTEGER;
19: TYPE t_entered_cr_type IS TABLE OF gms_bc_packets.entered_cr%type INDEX BY BINARY_INTEGER;
20: TYPE t_etype_type IS TABLE OF gms_bc_packets.expenditure_type%type INDEX BY BINARY_INTEGER;
21: TYPE t_exp_org_id_type IS TABLE OF gms_bc_packets.expenditure_organization_id%type INDEX BY BINARY_INTEGER;
22: TYPE t_exp_item_date_type IS TABLE OF gms_bc_packets.expenditure_item_date%type INDEX BY BINARY_INTEGER;
23: TYPE t_document_type_type IS TABLE OF gms_bc_packets.document_type%type INDEX BY BINARY_INTEGER;

Line 20: TYPE t_etype_type IS TABLE OF gms_bc_packets.expenditure_type%type INDEX BY BINARY_INTEGER;

16: TYPE t_award_id_type IS TABLE OF gms_bc_packets.award_id%type INDEX BY BINARY_INTEGER;
17: TYPE t_result_code_type IS TABLE OF gms_bc_packets.result_code%type INDEX BY BINARY_INTEGER;
18: TYPE t_entered_dr_type IS TABLE OF gms_bc_packets.entered_dr%type INDEX BY BINARY_INTEGER;
19: TYPE t_entered_cr_type IS TABLE OF gms_bc_packets.entered_cr%type INDEX BY BINARY_INTEGER;
20: TYPE t_etype_type IS TABLE OF gms_bc_packets.expenditure_type%type INDEX BY BINARY_INTEGER;
21: TYPE t_exp_org_id_type IS TABLE OF gms_bc_packets.expenditure_organization_id%type INDEX BY BINARY_INTEGER;
22: TYPE t_exp_item_date_type IS TABLE OF gms_bc_packets.expenditure_item_date%type INDEX BY BINARY_INTEGER;
23: TYPE t_document_type_type IS TABLE OF gms_bc_packets.document_type%type INDEX BY BINARY_INTEGER;
24: TYPE t_doc_header_id_type IS TABLE OF gms_bc_packets.document_header_id%type INDEX BY BINARY_INTEGER;

Line 21: TYPE t_exp_org_id_type IS TABLE OF gms_bc_packets.expenditure_organization_id%type INDEX BY BINARY_INTEGER;

17: TYPE t_result_code_type IS TABLE OF gms_bc_packets.result_code%type INDEX BY BINARY_INTEGER;
18: TYPE t_entered_dr_type IS TABLE OF gms_bc_packets.entered_dr%type INDEX BY BINARY_INTEGER;
19: TYPE t_entered_cr_type IS TABLE OF gms_bc_packets.entered_cr%type INDEX BY BINARY_INTEGER;
20: TYPE t_etype_type IS TABLE OF gms_bc_packets.expenditure_type%type INDEX BY BINARY_INTEGER;
21: TYPE t_exp_org_id_type IS TABLE OF gms_bc_packets.expenditure_organization_id%type INDEX BY BINARY_INTEGER;
22: TYPE t_exp_item_date_type IS TABLE OF gms_bc_packets.expenditure_item_date%type INDEX BY BINARY_INTEGER;
23: TYPE t_document_type_type IS TABLE OF gms_bc_packets.document_type%type INDEX BY BINARY_INTEGER;
24: TYPE t_doc_header_id_type IS TABLE OF gms_bc_packets.document_header_id%type INDEX BY BINARY_INTEGER;
25: TYPE t_doc_dist_id_type IS TABLE OF gms_bc_packets.document_distribution_id%type INDEX BY BINARY_INTEGER;

Line 22: TYPE t_exp_item_date_type IS TABLE OF gms_bc_packets.expenditure_item_date%type INDEX BY BINARY_INTEGER;

18: TYPE t_entered_dr_type IS TABLE OF gms_bc_packets.entered_dr%type INDEX BY BINARY_INTEGER;
19: TYPE t_entered_cr_type IS TABLE OF gms_bc_packets.entered_cr%type INDEX BY BINARY_INTEGER;
20: TYPE t_etype_type IS TABLE OF gms_bc_packets.expenditure_type%type INDEX BY BINARY_INTEGER;
21: TYPE t_exp_org_id_type IS TABLE OF gms_bc_packets.expenditure_organization_id%type INDEX BY BINARY_INTEGER;
22: TYPE t_exp_item_date_type IS TABLE OF gms_bc_packets.expenditure_item_date%type INDEX BY BINARY_INTEGER;
23: TYPE t_document_type_type IS TABLE OF gms_bc_packets.document_type%type INDEX BY BINARY_INTEGER;
24: TYPE t_doc_header_id_type IS TABLE OF gms_bc_packets.document_header_id%type INDEX BY BINARY_INTEGER;
25: TYPE t_doc_dist_id_type IS TABLE OF gms_bc_packets.document_distribution_id%type INDEX BY BINARY_INTEGER;
26: TYPE t_vendor_id_type IS TABLE OF gms_bc_packets.vendor_id%type INDEX BY BINARY_INTEGER;

Line 23: TYPE t_document_type_type IS TABLE OF gms_bc_packets.document_type%type INDEX BY BINARY_INTEGER;

19: TYPE t_entered_cr_type IS TABLE OF gms_bc_packets.entered_cr%type INDEX BY BINARY_INTEGER;
20: TYPE t_etype_type IS TABLE OF gms_bc_packets.expenditure_type%type INDEX BY BINARY_INTEGER;
21: TYPE t_exp_org_id_type IS TABLE OF gms_bc_packets.expenditure_organization_id%type INDEX BY BINARY_INTEGER;
22: TYPE t_exp_item_date_type IS TABLE OF gms_bc_packets.expenditure_item_date%type INDEX BY BINARY_INTEGER;
23: TYPE t_document_type_type IS TABLE OF gms_bc_packets.document_type%type INDEX BY BINARY_INTEGER;
24: TYPE t_doc_header_id_type IS TABLE OF gms_bc_packets.document_header_id%type INDEX BY BINARY_INTEGER;
25: TYPE t_doc_dist_id_type IS TABLE OF gms_bc_packets.document_distribution_id%type INDEX BY BINARY_INTEGER;
26: TYPE t_vendor_id_type IS TABLE OF gms_bc_packets.vendor_id%type INDEX BY BINARY_INTEGER;
27: TYPE t_exp_category_type IS TABLE OF gms_bc_packets.expenditure_category%type INDEX BY BINARY_INTEGER;

Line 24: TYPE t_doc_header_id_type IS TABLE OF gms_bc_packets.document_header_id%type INDEX BY BINARY_INTEGER;

20: TYPE t_etype_type IS TABLE OF gms_bc_packets.expenditure_type%type INDEX BY BINARY_INTEGER;
21: TYPE t_exp_org_id_type IS TABLE OF gms_bc_packets.expenditure_organization_id%type INDEX BY BINARY_INTEGER;
22: TYPE t_exp_item_date_type IS TABLE OF gms_bc_packets.expenditure_item_date%type INDEX BY BINARY_INTEGER;
23: TYPE t_document_type_type IS TABLE OF gms_bc_packets.document_type%type INDEX BY BINARY_INTEGER;
24: TYPE t_doc_header_id_type IS TABLE OF gms_bc_packets.document_header_id%type INDEX BY BINARY_INTEGER;
25: TYPE t_doc_dist_id_type IS TABLE OF gms_bc_packets.document_distribution_id%type INDEX BY BINARY_INTEGER;
26: TYPE t_vendor_id_type IS TABLE OF gms_bc_packets.vendor_id%type INDEX BY BINARY_INTEGER;
27: TYPE t_exp_category_type IS TABLE OF gms_bc_packets.expenditure_category%type INDEX BY BINARY_INTEGER;
28: TYPE t_revenue_category_type IS TABLE OF gms_bc_packets.revenue_category%type INDEX BY BINARY_INTEGER;

Line 25: TYPE t_doc_dist_id_type IS TABLE OF gms_bc_packets.document_distribution_id%type INDEX BY BINARY_INTEGER;

21: TYPE t_exp_org_id_type IS TABLE OF gms_bc_packets.expenditure_organization_id%type INDEX BY BINARY_INTEGER;
22: TYPE t_exp_item_date_type IS TABLE OF gms_bc_packets.expenditure_item_date%type INDEX BY BINARY_INTEGER;
23: TYPE t_document_type_type IS TABLE OF gms_bc_packets.document_type%type INDEX BY BINARY_INTEGER;
24: TYPE t_doc_header_id_type IS TABLE OF gms_bc_packets.document_header_id%type INDEX BY BINARY_INTEGER;
25: TYPE t_doc_dist_id_type IS TABLE OF gms_bc_packets.document_distribution_id%type INDEX BY BINARY_INTEGER;
26: TYPE t_vendor_id_type IS TABLE OF gms_bc_packets.vendor_id%type INDEX BY BINARY_INTEGER;
27: TYPE t_exp_category_type IS TABLE OF gms_bc_packets.expenditure_category%type INDEX BY BINARY_INTEGER;
28: TYPE t_revenue_category_type IS TABLE OF gms_bc_packets.revenue_category%type INDEX BY BINARY_INTEGER;
29: TYPE t_ind_cmp_set_id_type IS TABLE OF gms_bc_packets.ind_compiled_set_id%type INDEX BY BINARY_INTEGER;

Line 26: TYPE t_vendor_id_type IS TABLE OF gms_bc_packets.vendor_id%type INDEX BY BINARY_INTEGER;

22: TYPE t_exp_item_date_type IS TABLE OF gms_bc_packets.expenditure_item_date%type INDEX BY BINARY_INTEGER;
23: TYPE t_document_type_type IS TABLE OF gms_bc_packets.document_type%type INDEX BY BINARY_INTEGER;
24: TYPE t_doc_header_id_type IS TABLE OF gms_bc_packets.document_header_id%type INDEX BY BINARY_INTEGER;
25: TYPE t_doc_dist_id_type IS TABLE OF gms_bc_packets.document_distribution_id%type INDEX BY BINARY_INTEGER;
26: TYPE t_vendor_id_type IS TABLE OF gms_bc_packets.vendor_id%type INDEX BY BINARY_INTEGER;
27: TYPE t_exp_category_type IS TABLE OF gms_bc_packets.expenditure_category%type INDEX BY BINARY_INTEGER;
28: TYPE t_revenue_category_type IS TABLE OF gms_bc_packets.revenue_category%type INDEX BY BINARY_INTEGER;
29: TYPE t_ind_cmp_set_id_type IS TABLE OF gms_bc_packets.ind_compiled_set_id%type INDEX BY BINARY_INTEGER;
30: TYPE t_reference6_type IS TABLE OF po_bc_distributions.reference6%type INDEX BY BINARY_INTEGER;

Line 27: TYPE t_exp_category_type IS TABLE OF gms_bc_packets.expenditure_category%type INDEX BY BINARY_INTEGER;

23: TYPE t_document_type_type IS TABLE OF gms_bc_packets.document_type%type INDEX BY BINARY_INTEGER;
24: TYPE t_doc_header_id_type IS TABLE OF gms_bc_packets.document_header_id%type INDEX BY BINARY_INTEGER;
25: TYPE t_doc_dist_id_type IS TABLE OF gms_bc_packets.document_distribution_id%type INDEX BY BINARY_INTEGER;
26: TYPE t_vendor_id_type IS TABLE OF gms_bc_packets.vendor_id%type INDEX BY BINARY_INTEGER;
27: TYPE t_exp_category_type IS TABLE OF gms_bc_packets.expenditure_category%type INDEX BY BINARY_INTEGER;
28: TYPE t_revenue_category_type IS TABLE OF gms_bc_packets.revenue_category%type INDEX BY BINARY_INTEGER;
29: TYPE t_ind_cmp_set_id_type IS TABLE OF gms_bc_packets.ind_compiled_set_id%type INDEX BY BINARY_INTEGER;
30: TYPE t_reference6_type IS TABLE OF po_bc_distributions.reference6%type INDEX BY BINARY_INTEGER;
31: TYPE t_reference13_type IS TABLE OF po_bc_distributions.reference13%type INDEX BY BINARY_INTEGER;

Line 28: TYPE t_revenue_category_type IS TABLE OF gms_bc_packets.revenue_category%type INDEX BY BINARY_INTEGER;

24: TYPE t_doc_header_id_type IS TABLE OF gms_bc_packets.document_header_id%type INDEX BY BINARY_INTEGER;
25: TYPE t_doc_dist_id_type IS TABLE OF gms_bc_packets.document_distribution_id%type INDEX BY BINARY_INTEGER;
26: TYPE t_vendor_id_type IS TABLE OF gms_bc_packets.vendor_id%type INDEX BY BINARY_INTEGER;
27: TYPE t_exp_category_type IS TABLE OF gms_bc_packets.expenditure_category%type INDEX BY BINARY_INTEGER;
28: TYPE t_revenue_category_type IS TABLE OF gms_bc_packets.revenue_category%type INDEX BY BINARY_INTEGER;
29: TYPE t_ind_cmp_set_id_type IS TABLE OF gms_bc_packets.ind_compiled_set_id%type INDEX BY BINARY_INTEGER;
30: TYPE t_reference6_type IS TABLE OF po_bc_distributions.reference6%type INDEX BY BINARY_INTEGER;
31: TYPE t_reference13_type IS TABLE OF po_bc_distributions.reference13%type INDEX BY BINARY_INTEGER;
32: Type t_po_rate_type IS TABLE OF po_distributions_all.rate%type INDEX BY BINARY_INTEGER; -- Bug 5614467

Line 29: TYPE t_ind_cmp_set_id_type IS TABLE OF gms_bc_packets.ind_compiled_set_id%type INDEX BY BINARY_INTEGER;

25: TYPE t_doc_dist_id_type IS TABLE OF gms_bc_packets.document_distribution_id%type INDEX BY BINARY_INTEGER;
26: TYPE t_vendor_id_type IS TABLE OF gms_bc_packets.vendor_id%type INDEX BY BINARY_INTEGER;
27: TYPE t_exp_category_type IS TABLE OF gms_bc_packets.expenditure_category%type INDEX BY BINARY_INTEGER;
28: TYPE t_revenue_category_type IS TABLE OF gms_bc_packets.revenue_category%type INDEX BY BINARY_INTEGER;
29: TYPE t_ind_cmp_set_id_type IS TABLE OF gms_bc_packets.ind_compiled_set_id%type INDEX BY BINARY_INTEGER;
30: TYPE t_reference6_type IS TABLE OF po_bc_distributions.reference6%type INDEX BY BINARY_INTEGER;
31: TYPE t_reference13_type IS TABLE OF po_bc_distributions.reference13%type INDEX BY BINARY_INTEGER;
32: Type t_po_rate_type IS TABLE OF po_distributions_all.rate%type INDEX BY BINARY_INTEGER; -- Bug 5614467
33:

Line 35: TYPE t_brc_type IS TABLE OF gms_bc_packets.burdenable_raw_cost%type INDEX BY BINARY_INTEGER;

31: TYPE t_reference13_type IS TABLE OF po_bc_distributions.reference13%type INDEX BY BINARY_INTEGER;
32: Type t_po_rate_type IS TABLE OF po_distributions_all.rate%type INDEX BY BINARY_INTEGER; -- Bug 5614467
33:
34: --R12 AP Lines Uptake enhancement : Forward porting bug 4450291
35: TYPE t_brc_type IS TABLE OF gms_bc_packets.burdenable_raw_cost%type INDEX BY BINARY_INTEGER;
36: TYPE t_doc_dist_line_num_type IS TABLE OF ap_invoice_distributions_all.distribution_line_number%type INDEX BY BINARY_INTEGER;
37: TYPE t_invoice_type_code_type IS TABLE OF ap_invoices_all.invoice_type_lookup_code%type INDEX BY BINARY_INTEGER;
38: TYPE t_inv_source_type IS TABLE OF ap_invoices_all.source%type INDEX BY BINARY_INTEGER;
39: TYPE t_source_event_id_type IS TABLE OF gms_bc_packets.source_event_id%type INDEX BY BINARY_INTEGER;

Line 39: TYPE t_source_event_id_type IS TABLE OF gms_bc_packets.source_event_id%type INDEX BY BINARY_INTEGER;

35: TYPE t_brc_type IS TABLE OF gms_bc_packets.burdenable_raw_cost%type INDEX BY BINARY_INTEGER;
36: TYPE t_doc_dist_line_num_type IS TABLE OF ap_invoice_distributions_all.distribution_line_number%type INDEX BY BINARY_INTEGER;
37: TYPE t_invoice_type_code_type IS TABLE OF ap_invoices_all.invoice_type_lookup_code%type INDEX BY BINARY_INTEGER;
38: TYPE t_inv_source_type IS TABLE OF ap_invoices_all.source%type INDEX BY BINARY_INTEGER;
39: TYPE t_source_event_id_type IS TABLE OF gms_bc_packets.source_event_id%type INDEX BY BINARY_INTEGER;
40: TYPE t_event_type_code_type IS TABLE OF po_bc_distributions.event_type_code%type INDEX BY BINARY_INTEGER;
41: TYPE t_main_or_backing_type IS TABLE OF po_bc_distributions.main_or_backing_code%type INDEX BY BINARY_INTEGER;
42: TYPE t_parent_reversal_id_type IS TABLE OF ap_invoice_distributions_all.parent_reversal_id%type INDEX BY BINARY_INTEGER; -- Bug 5369296
43:

Line 111: Purpose : This procedure will delete pending records in gms_bc_packets associated with a

107:
108: /* -----------------------------------------------------------------------------------------------
109:
110: Procedure : delete_pending_txns
111: Purpose : This procedure will delete pending records in gms_bc_packets associated with a
112: request that has been terminated.
113: After deleting the records from gms_bc_packets, corresponding request_id entry will
114: be deleted from gms_concurrency_control table.
115:

Line 113: After deleting the records from gms_bc_packets, corresponding request_id entry will

109:
110: Procedure : delete_pending_txns
111: Purpose : This procedure will delete pending records in gms_bc_packets associated with a
112: request that has been terminated.
113: After deleting the records from gms_bc_packets, corresponding request_id entry will
114: be deleted from gms_concurrency_control table.
115:
116: -------------------------------------------------------------------------------------------------- */
117:

Line 136: -- Introduced new procedure to insert data into gms_bc_packets based on data

132: -- R12 Fundscheck Management uptake: AP/PO/REQ will no longer be saving data before
133: -- firing fundscheck hence existing logic is modified such that code which needs access
134: -- to AP/PO/REQ tables gets fired from main session and the insert/update code gets fired in
135: -- autonomous mode.
136: -- Introduced new procedure to insert data into gms_bc_packets based on data
137: -- in gl_bc_packets and AP,PO,REQ transaction tables.This procedure is fired from GL
138: -- main budgetory control API.
139:
140: PROCEDURE COPY_GL_PKT_TO_GMS_PKT (p_application_id IN NUMBER,