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.IBY_PAYMENT_FORMAT_VAL_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 33


                  SELECT pay_admin_assigned_ref_code
			FROM IBY_PAY_INSTRUCTIONS_ALL
                  WHERE  payment_instruction_id = p_pinstr_id;

Line: 78


							IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec,p_docErrorTab);

Line: 97


							IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec,p_docErrorTab);

Line: 111


                					IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec,p_docErrorTab);

Line: 130


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 131


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 162


	SELECT calling_app_doc_unique_ref2
		FROM IBY_DOCS_PAYABLE_ALL     -- added all
	WHERE	upper(document_type)='STANDARD'
	AND     calling_app_id=200
	AND     UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP')
        AND     payment_id in (select payment_id
                               from iby_payments_all
                               where payment_instruction_id = p_instruction_id);

Line: 176


		SELECT vendor_id, invoice_num
			FROM AP_INVOICES
		WHERE
			invoice_id=p_invoice_id;

Line: 184


           SELECT nvl(vendor_type_lookup_code, 'XXX')  -- Bug 6398944
             FROM AP_SUPPLIERS
            WHERE vendor_id = p_vendor_id;

Line: 234


				 IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 270


				  IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 308


 		  	 	 x_error_mesg :=  'All selected invoices must have one vendor type, either EMPLOYEE or NON-EMPLOYEE.';

Line: 313


				 IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 334


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 335


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 344


This procedure is responsible to insert the treasury symbol into the table FV_TP_TS_AMT_DATA along with the amount.
This table will later be used for the maximum treasury symbol validations.

*/


	PROCEDURE TREASURY_SYMBOLS_PROCESS
	(
	       p_format_name IN VARCHAR2,
               p_instruction_id   IN  NUMBER,
               p_payment_id  IN NUMBER,
	       p_invoice_id IN NUMBER,
	       p_docErrorTab IN  OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
	       p_docErrorRec IN  OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
	       x_error_code  OUT NOCOPY NUMBER,
	       x_error_mesg  OUT NOCOPY VARCHAR2
	)IS


	-- Get Distribution Code Combination Id And SOB
	CURSOR dist_sob_csr(p_invoice_id NUMBER)
	IS
		SELECT apid.dist_code_combination_id,
		       apid.set_of_books_id,
		       apid.org_id,
                       apid.amount,  -- added this for 5466103
                       glpv.chart_of_accounts_id
		   FROM ap_invoice_distributions_all apid,
                        gl_ledgers_public_v glpv
		WHERE apid.invoice_id      = p_invoice_id
                AND   apid.set_of_books_id = glpv.ledger_id;

Line: 379


		SELECT fvfp.fund_value fund_value,
	               fvts.treasury_symbol treasury_symbol
                   FROM fv_fund_parameters fvfp ,
		        fv_treasury_symbols fvts
		WHERE fvfp.treasury_symbol_id = fvts.treasury_symbol_id
		      AND
		      fvfp.set_of_books_id    = fvts.set_of_books_id
		      AND
		      fvfp.fund_value         = p_fund_value
		      AND
		      fvfp.set_of_books_id    = p_ledger_id ;

Line: 395


		SELECT ibypmt.payment_amount
		   FROM iby_docs_payable_all ibydocpay,
			iby_payments_all ibypmt
		WHERE ibydocpay.payment_id = p_payment_id
                AND   ibydocpay.calling_app_doc_unique_ref2 = p_invoice_id
		AND   ibydocpay.payment_id=ibypmt.payment_id
		AND   ibydocpay.calling_app_id=200
		AND   UPPER(ibydocpay.document_type)='STANDARD'
		AND   UPPER(ibydocpay.payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP');

Line: 452


				EXECUTE IMMEDIATE 'Select ' || l_seg_name || ' from GL_CODE_COMBINATIONS where code_combination_id= :ccid' INTO l_fund_val USING l_dist_sob_rec.dist_code_combination_id;

Line: 463


					IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 490


							SELECT count(*) INTO l_row_exist
								FROM FV_TP_TS_AMT_DATA
							WHERE
								treasury_symbol=l_tas_rec.treasury_symbol
								AND
								payment_instruction_id= p_instruction_id;

Line: 501


								INSERT INTO
									FV_TP_TS_AMT_DATA(treasury_symbol,
											  amount,
											  payment_instruction_id,
											  org_id,
											  set_of_books_id)
									VALUES(l_tas_rec.treasury_symbol,
									      l_dist_sob_rec.amount,    --changed from  l_amt_id_rec.payment_amount (bug 5466103)
										p_instruction_id,
										l_dist_sob_rec.org_id,
								                l_dist_sob_rec.set_of_books_id);

Line: 516


								UPDATE
							                FV_TP_TS_AMT_DATA
            							SET
							                amount = amount + l_dist_sob_rec.amount
							        WHERE
									treasury_symbol=l_tas_rec.treasury_symbol
									AND
									payment_instruction_id= p_instruction_id;

Line: 558


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 559


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 601


			    SELECT COUNT(*) INTO l_count_tas
					FROM FV_TP_TS_AMT_DATA
				WHERE payment_instruction_id = p_instruction_id;

Line: 611


					IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 619


			    SELECT COUNT(*) INTO l_count_tas
					FROM FV_TP_TS_AMT_DATA
				WHERE payment_instruction_id = p_instruction_id;

Line: 629


					IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 643


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 644


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 672


	SELECT address_line_1, address_line_2, town_or_city, region_2, postal_code
		FROM fv_system_parameters_v
	WHERE
	 	ou_org_id=p_org_id;

Line: 703


			IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 716


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 717


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 745


	 SELECT payee_address1,  payee_address2,  payee_address3, payee_address4, payee_city, payee_postal_code, payee_state
	 	FROM iby_payments_all
	 WHERE
	 	PAYMENT_ID=p_payment_id;

Line: 778


			IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 791


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 792


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 832


				IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 844


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 845


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 886


			IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 899


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 900


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 936


			SELECT idpa.payment_reason_code,
                               asup.vendor_type_lookup_code
                        INTO   l_payment_reason_code,
                               l_vendor_type_lookup_code
			FROM IBY_DOCS_PAYABLE_ALL idpa,     -- added all
                             ap_invoices_all aia,
                             ap_suppliers asup
			WHERE idpa.payment_id=p_payment_id
			AND   idpa.calling_app_doc_unique_ref2 = p_invoice_id
                        AND   aia.invoice_id = p_invoice_id
                        AND   asup.vendor_id = aia.vendor_id;

Line: 961


				   IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 972


				   IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 986


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 987


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 1027


			IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1039


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1040


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 1080


                    select party_name
                    into l_party_name
                    from hz_parties
                    where party_id = p_payee_party_id;

Line: 1096


			IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1109


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1110


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 1159


			IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1176


				IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1191


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1192


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 1235


				IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1248


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1249


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 1304


	        	IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1376


	        	IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1387


	        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1400


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1401


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 1431


	SELECT exclusive_payment_flag,
               invoice_num
	FROM ap_invoices_all
	WHERE
		invoice_id = p_invoice_id;

Line: 1458


					IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1470


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1471


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 1516


			IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1535


				IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1549


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1550


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 1590


                        select invoice_num
                        into   l_invoice_num
                        from   ap_invoices_all
                        where  invoice_id = p_invoice_id;

Line: 1604


				IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1617


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1618


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 1659


                        select hca.class_code,
                               ipa.internal_bank_account_id,
                               cba.bank_branch_id,
                               cba.bank_account_name
                        into   l_rfc_id,
                               l_bank_account_id,
                               l_bank_branch_id,
                               l_bank_account_name
                        from iby_payments_all ipa,
                             ce_bank_accounts cba,
                             hz_code_assignments  hca
                        where ipa.payment_id = p_payment_id
                        and   ipa.internal_bank_account_id = cba.bank_account_id(+)
                        and   hca.owner_table_name(+) = 'HZ_PARTIES'
                        and   hca.class_category(+)     = 'RFC_IDENTIFIER'
                        and   hca.owner_table_id(+) = cba.bank_branch_id;

Line: 1684


				 IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1698


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1699


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 1755


					IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1768


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1769


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 1813


				IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1826


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1827


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 1853


           	select ipia.org_id, haou.name
           	into l_org_id, l_org_name
           	from 	iby_pay_instructions_all ipia,
                	hr_all_organization_units haou
           	where ipia.payment_instruction_id = p_pay_instruction_id
           	and   ipia.org_id = haou.organization_id;

Line: 1861


          	select fed_employer_id_number
           	into l_fed_employer_id_number
           	from fv_operating_units_all
           	where org_id = l_org_id;

Line: 1874


			IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1887


			IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1897


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1898


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 1932


					IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1948


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1949


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);