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: 163


	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     document_status = 'PAYMENT_CREATED'
        AND     payment_id in (select payment_id
                               from iby_payments_all
                               where payment_instruction_id = p_instruction_id);

Line: 178


		SELECT vendor_id, invoice_num
			FROM AP_INVOICES
		WHERE
			invoice_id=p_invoice_id;

Line: 186


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

Line: 236


				 IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 272


				  IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 310


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

Line: 315


				 IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 336


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 337


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 346


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: 381


		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: 397


		SELECT ibydocpay.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: 453


				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: 464


					IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 492


							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: 503


								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_amt_id_rec.payment_amount,       -- changed from l_dist_sob_rec.amount(Bug 14542468)
										p_instruction_id,
										l_dist_sob_rec.org_id,
								                l_dist_sob_rec.set_of_books_id);

Line: 518


								UPDATE
							                FV_TP_TS_AMT_DATA
            							SET
							                amount = amount + l_amt_id_rec.payment_amount    -- changed from l_dist_sob_rec.amount(Bug 14542468)
							        WHERE
									treasury_symbol=l_tas_rec.treasury_symbol
									AND
									payment_instruction_id= p_instruction_id;

Line: 560


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 561


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 603


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

Line: 613


					IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 621


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

Line: 631


					IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 645


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 646


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 674


	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: 705


			IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 718


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 719


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 748


	 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
	 AND payment_status = 'INSTRUCTION_CREATED' ;

Line: 782


			IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 795


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 796


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 836


				IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 848


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 849


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 890


			IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 903


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 904


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 940


			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_supplier_sites_all asst,
                             ap_suppliers asup
			WHERE idpa.payment_id=p_payment_id
			AND   idpa.calling_app_doc_unique_ref2 = p_invoice_id
			AND idpa.document_status = 'PAYMENT_CREATED'
			AND idpa.calling_app_id=200
		        AND UPPER(idpa.payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP')
			AND idpa.supplier_site_id            = asst.vendor_site_id
			AND asst.vendor_id                   = asup.vendor_id ;

Line: 968


				   IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 979


				   IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 993


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 994


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 1034


			IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1046


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1047


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 1087


                    select party_name
                    into l_party_name
                    from hz_parties
                    where party_id = p_payee_party_id;

Line: 1103


			IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1116


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1117


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 1166


			IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1183


				IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1198


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1199


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 1242


				IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1255


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1256


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 1311


	        	IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1383


	        	IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1394


	        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1407


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1408


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 1439


	SELECT exclusive_payment_flag,
               calling_app_doc_ref_number
	FROM IBY_DOCS_PAYABLE_ALL
	WHERE calling_app_doc_unique_ref2 = p_invoice_id
	AND document_status = 'PAYMENT_CREATED'
	AND payment_id = p_payment_id
	AND calling_app_id=200
	AND UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP');

Line: 1469


					IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1481


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1482


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 1527


			IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1546


				IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1560


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1561


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 1602


                                        SELECT calling_app_doc_ref_number
                                        INTO l_invoice_num FROM IBY_DOCS_PAYABLE_ALL
                                        WHERE calling_app_doc_unique_ref2 = p_invoice_id
					AND payment_id = p_payment_id
				        AND calling_app_id=200
				        AND UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP');

Line: 1617


				IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1630


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1631


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 1672


                        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: 1697


				 IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1711


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1712


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 1768


					IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1781


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1782


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 1826


				IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1839


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1840


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 1866


           	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: 1874


          	select fed_employer_id_number
           	into l_fed_employer_id_number
           	from fv_operating_units_all
           	where org_id = l_org_id;

Line: 1887


			IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1900


			IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1910


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1911


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);

Line: 1945


					IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1961


                                IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(p_docErrorRec, p_docErrorTab);

Line: 1962


                                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',p_docErrorTab);