[Home] [Help]
1072: 1
1073: INTO
1074: dummy
1075: FROM
1076: sys.dual
1077: WHERE EXISTS
1078: ( SELECT 1
1079: FROM pa_expenditure_items ei
1080: WHERE ei.orig_transaction_reference = X_trx_ref
1661: l_all_neg_acc VARCHAR2(1); -- BUG 16451280
1662:
1663: Cursor c_check_fail(c_packet_id NUMBER) is
1664: Select 'X'
1665: from Dual
1666: Where exists (select 'Y' from pa_bc_packets
1667: Where packet_id = c_packet_id
1668: and substr(nvl(result_code, 'P'),1,1) = 'F');
1669:
7015:
7016: ELSE
7017: SELECT pa_expenditures_s.nextval
7018: INTO G_expenditure_id
7019: FROM sys.dual;
7020: END IF;
7021:
7022: pa_cc_utils.reset_curr_function;
7023: END loadExpCompareVars;
7229: pa_debug.G_err_Stage := 'Calling pa_transactions.InsItems';
7230: log_message('log_message: ' || pa_debug.G_err_Stage);
7231: END IF;
7232:
7233: select decode(G_gl_accted_flag,'N','N',decode(G_gl_posted_flag,'Y','Y','P')) into l_gl_accted_flag from dual;
7234:
7235: pa_transactions.InsItems(
7236: X_userid
7237: , 0
8421: decode(l_SysLinkTab(j),'ER', nvl(to_char(l_AcctExchRateTab(j)),'-DUMMY RATE-'),
8422: 'VI', nvl(to_char(l_AcctExchRateTab(j)),'-DUMMY RATE-'),
8423: '-DUMMY RATE-')
8424: Into l_Expend1, l_Expend2
8425: From Dual;
8426:
8427: IF ( FIRST_RECORD ) THEN
8428: IF PG_DEBUG = 'Y' THEN
8429: pa_debug.G_err_stage := 'Calling loadExpCompareVars';
11109: log_message('log_message: ' || pa_debug.G_err_Stage);
11110: END IF;
11111: Select Gl_Bc_Packets_s.NextVal
11112: Into l_Packet_Id
11113: From dual;
11114:
11115: /* Since we have divided the funds check packet insert code into 3 sections
11116: the bc packet id will be generated in each of the individual sections
11117: rather than in the beginning
11112: Into l_Packet_Id
11113: From dual;
11114:
11115: /* Since we have divided the funds check packet insert code into 3 sections
11116: the bc packet id will be generated in each of the individual sections
11117: rather than in the beginning
11118: */
11119:
11120: --Bug 2905892
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
13042: PRAGMA AUTONOMOUS_TRANSACTION;
13043:
13044: CURSOR c_gen_raw_bc_pkt IS
13045: SELECT Pa_Bc_Packets_s.NextVal
13046: FROM dual;
13047:
13048: CURSOR c_get_po_dist_id IS
13049: SELECT po_distribution_id
13050: FROM ap_invoice_distributions
13429: ,p_txn_interface_id --REL12
13430: ,g_enc_type_id_tbl(i)
13431: ,g_doc_hdr_id_2_tbl(i)
13432: ,g_doc_dist_type_tbl(i)
13433: From dual;
13434:
13435: IF PG_DEBUG = 'Y' THEN
13436: log_message('log_message: ' || 'In insert_ap_bc_pkt_autonomous - Inserted '||SQL%ROWCOUNT||' AP reversing raw and burden line(s) into bc packets');
13437: END IF;
13717: ,X_Ei_Id
13718: ,1
13719: ,g_xface_Txn_interface_tbl(i) --REL12
13720: ,g_xface_vendor_id_tbl(i)
13721: From dual;
13722:
13723: IF PG_DEBUG = 'Y' THEN
13724: log_message('log_message: ' || 'In insert_ap_bc_pkt_autonomous - Inserted '||SQL%ROWCOUNT||' ACTUAL raw line(s) into bc packets');
13725: END IF;
13800: AND txn1.adjusted_expenditure_item_id IS NOT NULL
13801: AND p_adj_act_fc_req = 'Y'
13802: UNION ALL -- R12 AP lines uptake : Prepayment changes : Added to pick current transaction for prepayment scenarios
13803: SELECT p_txn_interface_id
13804: FROM DUAL
13805: WHERE p_act_fc_req = 'Y');
13806:
13807: l_comm_fc_req VARCHAR2(1); -- Variable to identify whether commitment fundscheck is required
13808: l_act_fc_req VARCHAR2(1); -- Variable to identify whether actual fundscheck is required
13955: PRAGMA AUTONOMOUS_TRANSACTION;
13956:
13957: CURSOR c_gen_raw_bc_pkt IS
13958: SELECT Pa_Bc_Packets_s.NextVal
13959: FROM dual;
13960:
13961: CURSOR c_get_po_dist_id IS
13962: SELECT po_distribution_id
13963: FROM ap_invoice_distributions
14664: ,X_Ei_Id
14665: ,1
14666: ,g_xface_Txn_interface_tbl(i) --REL12
14667: ,g_xface_vendor_id_tbl(i)
14668: From dual;
14669:
14670: IF PG_DEBUG = 'Y' THEN
14671: log_message('log_message: ' || 'In insert_cash_ap_bc_pkt_auto - Before inserting adjusted ACTUAL raw line from transaction import table');
14672: END IF;
14878: p_act_fc_req IN VARCHAR2,
14879: p_adj_act_fc_req IN VARCHAR2) IS
14880: CURSOR c_gen_raw_bc_pkt IS
14881: SELECT Pa_Bc_Packets_s.NextVal
14882: FROM dual;
14883:
14884: CURSOR c_get_po_LINE_id (p_po_dist_id NUMBER) IS
14885: SELECT po_line_id
14886: FROM po_distributions_all
15239: AND bcc1.document_distribution_id = p_sys_ref3
15240: AND bcc1.parent_bc_packet_id = g_bc_packet_id_tbl(i)
15241: UNIOn ALL
15242: SELECT g_bc_comt_id_tbl(i)
15243: FROM DUAL);
15244:
15245: IF PG_DEBUG = 'Y' THEN
15246: log_message('log_message: ' || 'In insert_po_bc_packets_auto - Inserted '||SQL%ROWCOUNT||' PO reversing raw and burden line(s) into bc packets');
15247: END IF;
15371: and bcc1.parent_bc_packet_id = g_bc_packet_id_tbl(i)
15372: and bcc1.Status_Code in ('A','C')
15373: UNIOn ALL
15374: SELECT g_bc_packet_id_tbl(i)
15375: FROM DUAL);
15376:
15377: IF PG_DEBUG = 'Y' THEN
15378: log_message('log_message: ' || 'In insert_po_bc_packets_auto - Inserted '||SQL%ROWCOUNT||' PO reversing raw and burden line(s) into bc packets');
15379: END IF;
15600: ,X_Ei_Id
15601: ,1
15602: ,g_xface_Txn_interface_tbl(i)
15603: ,g_xface_vendor_id_tbl(i)
15604: From dual;
15605:
15606: IF PG_DEBUG = 'Y' THEN
15607: log_message('log_message: ' || 'In insert_po_bc_packets_auto - Inserted '||SQL%ROWCOUNT||' ACTUAL raw line(s) into bc packets');
15608: END IF;