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.PA_FUNDS_CONTROL_PKG1 dependencies on PA_BC_PACKETS_S

Line 1237: pa_bc_packets_s.nextval,

1233: l_update_login,
1234: sysdate,
1235: l_update_login,
1236: l_packet_id,
1237: pa_bc_packets_s.nextval,
1238: pbc.budget_version_id,
1239: pbc.project_id,
1240: pbc.task_id,
1241: pbc.expenditure_type,

Line 1377: pa_bc_packets_s.nextval,

1373: l_update_login,
1374: sysdate,
1375: l_update_login,
1376: l_packet_id,
1377: pa_bc_packets_s.nextval,
1378: pbc.budget_version_id,
1379: pbc.project_id,
1380: pbc.task_id,
1381: pbc.expenditure_type,

Line 1829: select pa_bc_packets_s.nextval

1825: g_tab_period_name(p_new_rec_index) := g_tab_period_name(p_copy_from_index);
1826: g_tab_parent_reversal_id(p_new_rec_index) := g_tab_parent_reversal_id(p_copy_from_index); -- Bug 5406690
1827:
1828: -- Bug 5406690
1829: select pa_bc_packets_s.nextval
1830: into g_tab_bc_packet_id(p_new_rec_index)
1831: from dual;
1832:
1833: IF pa_funds_control_pkg.g_debug_mode = 'Y' THEN

Line 2681: pa_bc_packets_s.nextval bc_packet_id -- Bug 5406690

2677: -- Bug 5403775 : Added below columns to derive pkt reference columns for backing docs such that
2678: -- they will point to the main doc
2679: POBC.origin_sequence_num,
2680: pobc.applied_to_dist_id_2,
2681: pa_bc_packets_s.nextval bc_packet_id -- Bug 5406690
2682: FROM po_bc_distributions pobc ,
2683: po_encumbrance_gt pogt,
2684: psa_bc_xla_events_gt xlaevt
2685: WHERE pobc.ae_event_id = xlaevt.event_id

Line 3495: select pa_bc_packets_s.nextval

3491: CLOSE cur_ap_bc_dist ;
3492:
3493: -- Bug 5406690
3494: FOR i IN 1..g_tab_doc_header_id.count LOOP
3495: select pa_bc_packets_s.nextval
3496: into g_tab_bc_packet_id(i)
3497: from dual;
3498: END LOOP;
3499:

Line 4386: Update pa_bc_packets set gl_row_number = g_tab_rowid(i)

4382: ---- the same while creating liquidation entries in IGC interface table.
4383:
4384: IF p_calling_module = 'CBC' THEN
4385: FORALL I in 1..g_tab_rowid.count
4386: Update pa_bc_packets set gl_row_number = g_tab_rowid(i)
4387: where bc_packet_id = g_tab_bc_packet_id (i); END IF;
4388:
4389: -------->6599207 ------END
4390:

Line 4820: pa_bc_packets_s.nextval,

4816: sysdate,
4817: l_update_login,
4818: ------ main columns-----------
4819: pbc.packet_id,
4820: pa_bc_packets_s.nextval,
4821: pbc.budget_version_id,
4822: pbc.project_id,
4823: pbc.task_id,
4824: pbc.expenditure_type,

Line 5003: pa_bc_packets_s.nextval,

4999: sysdate,
5000: l_update_login,
5001: ------ main columns-----------
5002: pbc.packet_id,
5003: pa_bc_packets_s.nextval,
5004: pbc.budget_version_id,
5005: pbc.project_id,
5006: pbc.task_id,
5007: et.expenditure_type,

Line 5786: pa_bc_packets_s.nextval,

5782: sysdate,
5783: l_update_login,
5784: ------ main columns-----------
5785: pbc.packet_id,
5786: pa_bc_packets_s.nextval,
5787: pbc.budget_version_id,
5788: pbc.project_id,
5789: pbc.task_id,
5790: pbc.expenditure_type,

Line 5966: pa_bc_packets_s.nextval,

5962: sysdate,
5963: l_update_login,
5964: ------ main columns-----------
5965: pbc.packet_id,
5966: pa_bc_packets_s.nextval,
5967: pbc.budget_version_id,
5968: pbc.project_id,
5969: pbc.task_id,
5970: pbc.expenditure_type, --- p_exp_type

Line 6153: pa_bc_packets_s.nextval,

6149: sysdate,
6150: l_update_login,
6151: ------ main columns-----------
6152: pbc.packet_id,
6153: pa_bc_packets_s.nextval,
6154: pbc.budget_version_id,
6155: pbc.project_id,
6156: pbc.task_id,
6157: l_tab_icc_exp_type(indx),

Line 6333: pa_bc_packets_s.nextval,

6329: sysdate,
6330: l_update_login,
6331: ------ main columns-----------
6332: pbc.packet_id,
6333: pa_bc_packets_s.nextval,
6334: pbc.budget_version_id,
6335: pbc.project_id,
6336: pbc.task_id,
6337: /* Bug fix:3026988

Line 7537: p_set_of_books_id IN pa_bc_packets.set_of_books_id%TYPE,

7533: p_time_phase_type_code IN pa_budget_entry_methods.time_phased_type_code%TYPE,
7534: p_expenditure_item_date IN DATE,
7535: p_amount_type IN pa_budgetary_control_options.amount_type%TYPE,
7536: p_boundary_code IN pa_budgetary_control_options.boundary_code%TYPE,
7537: p_set_of_books_id IN pa_bc_packets.set_of_books_id%TYPE,
7538: x_start_date OUT NOCOPY DATE,
7539: x_end_date OUT NOCOPY DATE,
7540: x_error_code OUT NOCOPY NUMBER,
7541: x_err_buff OUT NOCOPY VARCHAR2,

Line 8080: p_set_of_books_id IN pa_bc_packets.set_of_books_id%TYPE,

8076: p_time_phase_type_code IN pa_budget_entry_methods.time_phased_type_code%TYPE,
8077: p_expenditure_item_date IN DATE,
8078: p_amount_type IN pa_budgetary_control_options.amount_type%TYPE,
8079: p_boundary_code IN pa_budgetary_control_options.boundary_code%TYPE,
8080: p_set_of_books_id IN pa_bc_packets.set_of_books_id%TYPE,
8081: p_type IN varchar2 -- START_DATE or END_DATE OR RESULT_CODE
8082: ) return DATE is
8083:
8084: l_start_date date;

Line 9343: pa_bc_packets_s.nextval

9339: NULL distribution_type,
9340: NULL po_release_Id,
9341: PA_FUNDS_CONTROL_UTILS.get_encum_type_id(igc.project_id,'STD') enc_type_id,
9342: igchead.vendor_id,
9343: pa_bc_packets_s.nextval
9344: FROM pa_tasks pkt,
9345: pa_projects_all pp,
9346: igc_cc_acct_lines igc,
9347: igc_cc_det_pf igcpf,

Line 9426: pa_bc_packets_s.nextval

9422: 'Provisional','CC_P_CO')
9423: pkt_reference1,
9424: igci.cc_header_id pkt_reference2,
9425: igci.cc_acct_line_id pkt_reference3,
9426: pa_bc_packets_s.nextval
9427: FROM
9428: pa_tasks pkt,
9429: pa_projects_all pp,
9430: igc_cc_interface igci,