[Home] [Help]
996: 1
997: INTO
998: dummy
999: FROM
1000: sys.dual
1001: WHERE EXISTS
1002: ( SELECT 1
1003: FROM pa_expenditure_items ei
1004: WHERE ei.orig_transaction_reference = X_trx_ref
1547: l_cwk_amt_updated VARCHAR2(1) := 'N';
1548:
1549: Cursor c_check_fail(c_packet_id NUMBER) is
1550: Select 'X'
1551: from Dual
1552: Where exists (select 'Y' from pa_bc_packets
1553: Where packet_id = c_packet_id
1554: and substr(nvl(result_code, 'P'),1,1) = 'F');
1555:
6452:
6453: ELSE
6454: SELECT pa_expenditures_s.nextval
6455: INTO G_expenditure_id
6456: FROM sys.dual;
6457: END IF;
6458:
6459: pa_cc_utils.reset_curr_function;
6460: END loadExpCompareVars;
6636: pa_debug.G_err_Stage := 'Calling pa_transactions.InsItems';
6637: log_message('log_message: ' || pa_debug.G_err_Stage);
6638: END IF;
6639:
6640: select decode(G_gl_accted_flag,'N','N',decode(G_gl_posted_flag,'Y','Y','P')) into l_gl_accted_flag from dual;
6641:
6642: pa_transactions.InsItems(
6643: X_userid
6644: , 0
7744: decode(l_SysLinkTab(j),'ER', nvl(to_char(l_AcctExchRateTab(j)),'-DUMMY RATE-'),
7745: 'VI', nvl(to_char(l_AcctExchRateTab(j)),'-DUMMY RATE-'),
7746: '-DUMMY RATE-')
7747: Into l_Expend1, l_Expend2
7748: From Dual;
7749:
7750: IF ( FIRST_RECORD ) THEN
7751: IF PG_DEBUG = 'Y' THEN
7752: pa_debug.G_err_stage := 'Calling loadExpCompareVars';
10268: log_message('log_message: ' || pa_debug.G_err_Stage);
10269: END IF;
10270: Select Gl_Bc_Packets_s.NextVal
10271: Into l_Packet_Id
10272: From dual;
10273:
10274: /* Since we have divided the funds check packet insert code into 3 sections
10275: the bc packet id will be generated in each of the individual sections
10276: rather than in the beginning
10271: Into l_Packet_Id
10272: From dual;
10273:
10274: /* Since we have divided the funds check packet insert code into 3 sections
10275: the bc packet id will be generated in each of the individual sections
10276: rather than in the beginning
10277: */
10278:
10279: --Bug 2905892
11973: AND txn1.adjusted_expenditure_item_id IS NOT NULL
11974: AND p_adj_act_fc_req = 'Y'
11975: UNION ALL -- R12 AP lines uptake : Prepayment changes : Added to pick current transaction for prepayment scenarios
11976: SELECT p_txn_interface_id
11977: FROM DUAL
11978: WHERE p_act_fc_req = 'Y');
11979:
11980: l_comm_fc_req VARCHAR2(1); -- Variable to identify whether commitment fundscheck is required
11981: l_act_fc_req VARCHAR2(1); -- Variable to identify whether actual fundscheck is required
12141: PRAGMA AUTONOMOUS_TRANSACTION;
12142:
12143: CURSOR c_gen_raw_bc_pkt IS
12144: SELECT Pa_Bc_Packets_s.NextVal
12145: FROM dual;
12146:
12147: CURSOR c_get_po_dist_id IS
12148: SELECT po_distribution_id
12149: FROM ap_invoice_distributions
12506: ,p_txn_interface_id --REL12
12507: ,g_enc_type_id_tbl(i)
12508: ,g_doc_hdr_id_2_tbl(i)
12509: ,g_doc_dist_type_tbl(i)
12510: From dual;
12511:
12512: IF PG_DEBUG = 'Y' THEN
12513: log_message('log_message: ' || 'In insert_ap_bc_pkt_autonomous - Inserted '||SQL%ROWCOUNT||' AP reversing raw and burden line(s) into bc packets');
12514: END IF;
12790: ,'EXP'
12791: ,X_Ei_Id
12792: ,1
12793: ,g_xface_Txn_interface_tbl(i) --REL12
12794: From dual;
12795:
12796: IF PG_DEBUG = 'Y' THEN
12797: log_message('log_message: ' || 'In insert_ap_bc_pkt_autonomous - Inserted '||SQL%ROWCOUNT||' ACTUAL raw line(s) into bc packets');
12798: END IF;
12872: AND txn1.adjusted_expenditure_item_id IS NOT NULL
12873: AND p_adj_act_fc_req = 'Y'
12874: UNION ALL -- R12 AP lines uptake : Prepayment changes : Added to pick current transaction for prepayment scenarios
12875: SELECT p_txn_interface_id
12876: FROM DUAL
12877: WHERE p_act_fc_req = 'Y');
12878:
12879: l_comm_fc_req VARCHAR2(1); -- Variable to identify whether commitment fundscheck is required
12880: l_act_fc_req VARCHAR2(1); -- Variable to identify whether actual fundscheck is required
13025: PRAGMA AUTONOMOUS_TRANSACTION;
13026:
13027: CURSOR c_gen_raw_bc_pkt IS
13028: SELECT Pa_Bc_Packets_s.NextVal
13029: FROM dual;
13030:
13031: CURSOR c_get_po_dist_id IS
13032: SELECT po_distribution_id
13033: FROM ap_invoice_distributions
13706: ,'EXP'
13707: ,X_Ei_Id
13708: ,1
13709: ,g_xface_Txn_interface_tbl(i) --REL12
13710: From dual;
13711:
13712: IF PG_DEBUG = 'Y' THEN
13713: log_message('log_message: ' || 'In insert_cash_ap_bc_pkt_auto - Before inserting adjusted ACTUAL raw line from transaction import table');
13714: END IF;
13918: p_act_fc_req IN VARCHAR2,
13919: p_adj_act_fc_req IN VARCHAR2) IS
13920: CURSOR c_gen_raw_bc_pkt IS
13921: SELECT Pa_Bc_Packets_s.NextVal
13922: FROM dual;
13923:
13924: CURSOR c_get_po_LINE_id (p_po_dist_id NUMBER) IS
13925: SELECT po_line_id
13926: FROM po_distributions_all
14261: AND bcc1.document_distribution_id = p_sys_ref3
14262: AND bcc1.parent_bc_packet_id = g_bc_packet_id_tbl(i)
14263: UNIOn ALL
14264: SELECT g_bc_comt_id_tbl(i)
14265: FROM DUAL);
14266:
14267: IF PG_DEBUG = 'Y' THEN
14268: log_message('log_message: ' || 'In insert_po_bc_packets_auto - Inserted '||SQL%ROWCOUNT||' PO reversing raw and burden line(s) into bc packets');
14269: END IF;
14391: and bcc1.parent_bc_packet_id = g_bc_packet_id_tbl(i)
14392: and bcc1.Status_Code in ('A','C')
14393: UNIOn ALL
14394: SELECT g_bc_packet_id_tbl(i)
14395: FROM DUAL);
14396:
14397: IF PG_DEBUG = 'Y' THEN
14398: log_message('log_message: ' || 'In insert_po_bc_packets_auto - Inserted '||SQL%ROWCOUNT||' PO reversing raw and burden line(s) into bc packets');
14399: END IF;
14613: ,'EXP'
14614: ,X_Ei_Id
14615: ,1
14616: ,g_xface_Txn_interface_tbl(i)
14617: From dual;
14618:
14619: IF PG_DEBUG = 'Y' THEN
14620: log_message('log_message: ' || 'In insert_po_bc_packets_auto - Inserted '||SQL%ROWCOUNT||' ACTUAL raw line(s) into bc packets');
14621: END IF;