DBA Data[Home] [Help]

APPS.PO_SETUP_S2 SQL Statements

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

Line: 21

                             x_update_date         	     OUT NOCOPY    DATE,
                             x_currency_code                 OUT NOCOPY VARCHAR2,
                             x_coa_id                        OUT NOCOPY NUMBER,
                             x_po_encumberance_flag          OUT NOCOPY VARCHAR2,
                             x_req_encumberance_flag         OUT NOCOPY VARCHAR2,
                             x_ship_to_location_id        IN OUT NOCOPY NUMBER,
                             x_bill_to_location_id        IN OUT NOCOPY NUMBER,
                             x_fob_lookup_code            IN OUT NOCOPY VARCHAR2,
                             x_freight_terms_lookup_code  IN OUT NOCOPY VARCHAR2,
                             x_terms_id                   IN OUT NOCOPY NUMBER,
                             x_default_rate_type          IN OUT NOCOPY VARCHAR2,
                             x_taxable_flag                  OUT NOCOPY VARCHAR2,
                             x_receiving_flag                OUT NOCOPY VARCHAR2,
                             x_enforce_buyer_name_flag       OUT NOCOPY VARCHAR2,
                             x_enforce_buyer_auth_flag       OUT NOCOPY VARCHAR2,
                             x_line_type_id               IN OUT NOCOPY NUMBER,
                             x_manual_po_num_type            OUT NOCOPY VARCHAR2,
                             x_po_num_code                   OUT NOCOPY VARCHAR2,
                             x_price_lookup_code             OUT NOCOPY VARCHAR2,
                             x_invoice_close_tolerance       OUT NOCOPY NUMBER,
                             x_receive_close_tolerance       OUT NOCOPY NUMBER,
                             x_security_structure_id         OUT NOCOPY NUMBER,
                             x_expense_accrual_code          OUT NOCOPY VARCHAR2,
                             x_rev_sort_ordering             OUT NOCOPY NUMBER,
                             x_min_rel_amount                OUT NOCOPY NUMBER,
                             x_notify_blanket_flag           OUT NOCOPY VARCHAR2,
                             x_budgetary_control_flag        OUT NOCOPY VARCHAR2,
                             x_user_defined_req_num_code     OUT NOCOPY VARCHAR2,
                             x_rfq_required_flag             OUT NOCOPY VARCHAR2,
                             x_manual_req_num_type           OUT NOCOPY VARCHAR2,
                             x_enforce_full_lot_qty          OUT NOCOPY VARCHAR2,
                             x_disposition_warning_flag      OUT NOCOPY VARCHAR2,
                             x_reserve_at_completion_flag    OUT NOCOPY VARCHAR2,
                             x_user_defined_rcpt_num_code    OUT NOCOPY VARCHAR2,
                             x_manual_rcpt_num_type          OUT NOCOPY VARCHAR2,
			     x_use_positions_flag	     OUT NOCOPY VARCHAR2,
			     x_default_quote_warning_delay   OUT NOCOPY NUMBER,
		  	     x_inspection_required_flag      OUT NOCOPY VARCHAR2,
		  	     x_user_defined_quote_num_code   OUT NOCOPY VARCHAR2,
		  	     x_manual_quote_num_type	     OUT NOCOPY VARCHAR2,
		  	     x_user_defined_rfq_num_code     OUT NOCOPY VARCHAR2,
		  	     x_manual_rfq_num_type	     OUT NOCOPY VARCHAR2,
		  	     x_ship_via_lookup_code	  IN OUT NOCOPY VARCHAR2,
		  	     x_qty_rcv_tolerance	     OUT NOCOPY NUMBER,
			     x_line_type		     OUT NOCOPY VARCHAR2,
			     x_item_tax_override_popup	     OUT NOCOPY VARCHAR2,
			     x_item_account_override_popup   OUT NOCOPY VARCHAR2,
			     x_curr_tax_override_popup       OUT NOCOPY VARCHAR2,
			     x_curr_account_override_popup   OUT NOCOPY VARCHAR2,
			     x_use_ap_accrual_account 	     OUT NOCOPY VARCHAR2,
			     x_destination_expense 	     OUT NOCOPY VARCHAR2,
			     x_destination_shop_floor 	     OUT NOCOPY VARCHAR2,
			     x_legal_requisition_type 	     OUT NOCOPY VARCHAR2,
			     x_req_source_internal	     OUT NOCOPY VARCHAR2,
			     x_req_source_purchase           OUT NOCOPY VARCHAR2,
			     x_req_incomplete		     OUT NOCOPY VARCHAR2,
			     x_fob_disp			     OUT NOCOPY VARCHAR2,
			     x_freight_terms_disp	     OUT NOCOPY VARCHAR2,
			     x_internal_access		     OUT NOCOPY VARCHAR2,
			     x_purchase_access		     OUT NOCOPY VARCHAR2,
			     x_internal_security	     OUT NOCOPY VARCHAR2,
			     x_purchase_security	     OUT NOCOPY VARCHAR2,
			     x_employee_id		     OUT NOCOPY NUMBER,
			     x_employee_name		     OUT NOCOPY VARCHAR2,
			     x_employee_is_buyer_flag	     OUT NOCOPY VARCHAR2,
			     x_requestor_location_id	  IN OUT NOCOPY NUMBER,
			     x_bill_to_location		  IN OUT NOCOPY VARCHAR2,
			     x_ship_to_location           IN OUT NOCOPY VARCHAR2,
			     x_ship_org_code		  IN OUT NOCOPY VARCHAR2,
			     x_ship_org_name		  IN OUT NOCOPY VARCHAR2,
			     x_default_rate_type_disp	  IN OUT NOCOPY VARCHAR2,
			     x_requestor_location	  IN OUT NOCOPY VARCHAR2,
			     x_requestor_org_id		  IN OUT NOCOPY NUMBER,
			     x_requestor_org		  IN OUT NOCOPY VARCHAR2,
			     x_requestor_org_code	  IN OUT NOCOPY VARCHAR2,
			     x_destination_inventory	     OUT NOCOPY VARCHAR2,
                             x_gl_set_of_bks_id              OUT NOCOPY VARCHAR2,
			     x_combined_install_statuses     OUT NOCOPY VARCHAR2,
                             x_payment_terms              IN OUT NOCOPY VARCHAR2,
			     x_acceptance_required_flag      OUT NOCOPY VARCHAR2) IS    /* Bug 7518967 : Default Acceptance Required Check ER */


 x_progress     		VARCHAR2  (3) := NULL;
Line: 127

                                x_update_date,
                                x_currency_code,
                                x_coa_id               ,
                                x_po_encumberance_flag  ,
                                x_req_encumberance_flag  ,
                                x_ship_to_location_id      ,
                                x_bill_to_location_id       ,
                                x_fob_lookup_code         ,
                                x_freight_terms_lookup_code,
                                x_terms_id           ,
                                x_default_rate_type   ,
                                x_taxable_flag         ,
                                x_receiving_flag        ,
                                x_enforce_buyer_name_flag,
                                x_enforce_buyer_auth_flag,
                                x_line_type_id       ,
                                x_manual_po_num_type  ,
                                x_po_num_code          ,
                                x_price_lookup_code     ,
                                x_invoice_close_tolerance,
                                x_receive_close_tolerance,
                                x_security_structure_id,
                                x_expense_accrual_code,
                                x_rev_sort_ordering,
                                x_min_rel_amount    ,
                                x_notify_blanket_flag,
                                x_budgetary_control_flag,
                                x_user_defined_req_num_code,
                                x_rfq_required_flag,
                                x_manual_req_num_type,
                                x_enforce_full_lot_qty,
                                x_disposition_warning_flag,
                                x_reserve_at_completion_flag,
                                x_user_defined_rcpt_num_code,
                                x_manual_rcpt_num_type,
  				x_use_positions_flag,
  				x_default_quote_warning_delay,
  				x_inspection_required_flag,
  				x_user_defined_quote_num_code,
  				x_manual_quote_num_type,
  				x_user_defined_rfq_num_code,
  				x_manual_rfq_num_type,
  				x_ship_via_lookup_code,
  				x_qty_rcv_tolerance,
				x_line_type,
  				x_item_tax_override_popup,
  				x_item_account_override_popup,
  				x_curr_tax_override_popup,
  				x_curr_account_override_popup,
  				x_use_ap_accrual_account,
  				x_destination_expense,
				x_destination_shop_floor,
  				x_legal_requisition_type,
  				x_req_source_internal,
  				x_req_source_purchase,
  				x_req_incomplete,
   				x_fob_disp,
  				x_freight_terms_disp,
  				x_internal_access,
  				x_purchase_access,
  				x_internal_security,
  				x_purchase_security,
  				x_employee_id,
  				x_employee_name,
  				x_employee_is_buyer_flag,
  				x_requestor_location_id,
  				x_bill_to_location,
  				x_ship_to_location,
  				x_ship_org_code	,
  				x_ship_org_name,
				x_default_rate_type_disp,
				x_requestor_location,
				x_requestor_org_id,
				x_requestor_org,
				x_requestor_org_code,
				x_destination_inventory,
                                x_gl_set_of_bks_id,
				x_acceptance_required_flag);      /* Bug 7518967 : Default Acceptance Required Check ER */