DBA Data[Home] [Help]

APPS.PA_FUNDS_CONTROL_PKG1 dependencies on PA_BC_PACKETS_S

Line 1219: pa_bc_packets_s.nextval,

1215: l_update_login,
1216: sysdate,
1217: l_update_login,
1218: l_packet_id,
1219: pa_bc_packets_s.nextval,
1220: pbc.budget_version_id,
1221: pbc.project_id,
1222: pbc.task_id,
1223: pbc.expenditure_type,

Line 1357: pa_bc_packets_s.nextval,

1353: l_update_login,
1354: sysdate,
1355: l_update_login,
1356: l_packet_id,
1357: pa_bc_packets_s.nextval,
1358: pbc.budget_version_id,
1359: pbc.project_id,
1360: pbc.task_id,
1361: pbc.expenditure_type,

Line 1783: select pa_bc_packets_s.nextval

1779: g_tab_period_name(p_new_rec_index) := g_tab_period_name(p_copy_from_index);
1780: g_tab_parent_reversal_id(p_new_rec_index) := g_tab_parent_reversal_id(p_copy_from_index); -- Bug 5406690
1781:
1782: -- Bug 5406690
1783: select pa_bc_packets_s.nextval
1784: into g_tab_bc_packet_id(p_new_rec_index)
1785: from dual;
1786:
1787: IF pa_funds_control_pkg.g_debug_mode = 'Y' THEN

Line 2635: pa_bc_packets_s.nextval bc_packet_id -- Bug 5406690

2631: -- Bug 5403775 : Added below columns to derive pkt reference columns for backing docs such that
2632: -- they will point to the main doc
2633: POBC.origin_sequence_num,
2634: pobc.applied_to_dist_id_2,
2635: pa_bc_packets_s.nextval bc_packet_id -- Bug 5406690
2636: FROM po_bc_distributions pobc ,
2637: po_encumbrance_gt pogt,
2638: psa_bc_xla_events_gt xlaevt
2639: WHERE pobc.ae_event_id = xlaevt.event_id

Line 3216: select pa_bc_packets_s.nextval

3212: CLOSE cur_ap_bc_dist ;
3213:
3214: -- Bug 5406690
3215: FOR i IN 1..g_tab_doc_header_id.count LOOP
3216: select pa_bc_packets_s.nextval
3217: into g_tab_bc_packet_id(i)
3218: from dual;
3219: END LOOP;
3220:

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

4097: ---- the same while creating liquidation entries in IGC interface table.
4098:
4099: IF p_calling_module = 'CBC' THEN
4100: FORALL I in 1..g_tab_rowid.count
4101: Update pa_bc_packets set gl_row_number = g_tab_rowid(i)
4102: where bc_packet_id = g_tab_bc_packet_id (i); END IF;
4103:
4104: -------->6599207 ------END
4105:

Line 4521: pa_bc_packets_s.nextval,

4517: sysdate,
4518: l_update_login,
4519: ------ main columns-----------
4520: pbc.packet_id,
4521: pa_bc_packets_s.nextval,
4522: pbc.budget_version_id,
4523: pbc.project_id,
4524: pbc.task_id,
4525: pbc.expenditure_type,

Line 4704: pa_bc_packets_s.nextval,

4700: sysdate,
4701: l_update_login,
4702: ------ main columns-----------
4703: pbc.packet_id,
4704: pa_bc_packets_s.nextval,
4705: pbc.budget_version_id,
4706: pbc.project_id,
4707: pbc.task_id,
4708: et.expenditure_type,

Line 5465: pa_bc_packets_s.nextval,

5461: sysdate,
5462: l_update_login,
5463: ------ main columns-----------
5464: pbc.packet_id,
5465: pa_bc_packets_s.nextval,
5466: pbc.budget_version_id,
5467: pbc.project_id,
5468: pbc.task_id,
5469: pbc.expenditure_type,

Line 5645: pa_bc_packets_s.nextval,

5641: sysdate,
5642: l_update_login,
5643: ------ main columns-----------
5644: pbc.packet_id,
5645: pa_bc_packets_s.nextval,
5646: pbc.budget_version_id,
5647: pbc.project_id,
5648: pbc.task_id,
5649: pbc.expenditure_type, --- p_exp_type

Line 5832: pa_bc_packets_s.nextval,

5828: sysdate,
5829: l_update_login,
5830: ------ main columns-----------
5831: pbc.packet_id,
5832: pa_bc_packets_s.nextval,
5833: pbc.budget_version_id,
5834: pbc.project_id,
5835: pbc.task_id,
5836: l_tab_icc_exp_type(indx),

Line 6012: pa_bc_packets_s.nextval,

6008: sysdate,
6009: l_update_login,
6010: ------ main columns-----------
6011: pbc.packet_id,
6012: pa_bc_packets_s.nextval,
6013: pbc.budget_version_id,
6014: pbc.project_id,
6015: pbc.task_id,
6016: /* Bug fix:3026988

Line 7190: p_set_of_books_id IN pa_bc_packets.set_of_books_id%TYPE,

7186: p_time_phase_type_code IN pa_budget_entry_methods.time_phased_type_code%TYPE,
7187: p_expenditure_item_date IN DATE,
7188: p_amount_type IN pa_budgetary_control_options.amount_type%TYPE,
7189: p_boundary_code IN pa_budgetary_control_options.boundary_code%TYPE,
7190: p_set_of_books_id IN pa_bc_packets.set_of_books_id%TYPE,
7191: x_start_date OUT NOCOPY DATE,
7192: x_end_date OUT NOCOPY DATE,
7193: x_error_code OUT NOCOPY NUMBER,
7194: x_err_buff OUT NOCOPY VARCHAR2,

Line 7711: p_set_of_books_id IN pa_bc_packets.set_of_books_id%TYPE,

7707: p_time_phase_type_code IN pa_budget_entry_methods.time_phased_type_code%TYPE,
7708: p_expenditure_item_date IN DATE,
7709: p_amount_type IN pa_budgetary_control_options.amount_type%TYPE,
7710: p_boundary_code IN pa_budgetary_control_options.boundary_code%TYPE,
7711: p_set_of_books_id IN pa_bc_packets.set_of_books_id%TYPE,
7712: p_type IN varchar2 -- START_DATE or END_DATE OR RESULT_CODE
7713: ) return DATE is
7714:
7715: l_start_date date;

Line 8955: pa_bc_packets_s.nextval

8951: NULL distribution_type,
8952: NULL po_release_Id,
8953: PA_FUNDS_CONTROL_UTILS.get_encum_type_id(igc.project_id,'STD') enc_type_id,
8954: igchead.vendor_id,
8955: pa_bc_packets_s.nextval
8956: FROM pa_tasks pkt,
8957: pa_projects_all pp,
8958: igc_cc_acct_lines igc,
8959: igc_cc_det_pf igcpf,

Line 9038: pa_bc_packets_s.nextval

9034: 'Provisional','CC_P_CO')
9035: pkt_reference1,
9036: igci.cc_header_id pkt_reference2,
9037: igci.cc_acct_line_id pkt_reference3,
9038: pa_bc_packets_s.nextval
9039: FROM
9040: pa_tasks pkt,
9041: pa_projects_all pp,
9042: igc_cc_interface igci,