APPS.JAI_CMN_TAX_DEFAULTATION_PKG dependencies on PO_REQUISITION_LINES_ALL

Line 33: from po_requisition_lines_all

29: ) IS
30: PRAGMA AUTONOMOUS_TRANSACTION;
31: BEGIN
32: select quantity into p_prev_quantity
33: from po_requisition_lines_all
34: where requisition_line_id = p_req_line_id;
35: END;
36:
37: PROCEDURE ja_in_cust_default_taxes (

Line 376: , p_modified_by_agent_flag po_requisition_lines_all.modified_by_agent_flag%type default NULL /*Added for Bug 8241905*/

372: , p_source_table_name jai_cmn_document_taxes.source_table_name%type default null
373: , p_action varchar2 default null
374: /** End bug 5631784 */
375: , pv_retroprice_changed IN VARCHAR2 DEFAULT 'N' --Added by Kevin Cheng for Retroactive Price 2008/01/13
376: , p_modified_by_agent_flag po_requisition_lines_all.modified_by_agent_flag%type default NULL /*Added for Bug 8241905*/
377: , p_parent_req_line_id po_requisition_lines_all.parent_req_line_id%type default NULL /*Added for Bug 8241905*/
378: , p_max_tax_line NUMBER DEFAULT 0 /*Added for Bug 8371741*/
379: , p_max_rgm_tax_line NUMBER DEFAULT 0 /*Added for Bug 8371741*/
380: --, pn_gst_assessable_value NUMBER DEFAULT 0 -- Added by Jia for GST Bug#10043656 on 2010/09/10

Line 377: , p_parent_req_line_id po_requisition_lines_all.parent_req_line_id%type default NULL /*Added for Bug 8241905*/

373: , p_action varchar2 default null
374: /** End bug 5631784 */
375: , pv_retroprice_changed IN VARCHAR2 DEFAULT 'N' --Added by Kevin Cheng for Retroactive Price 2008/01/13
376: , p_modified_by_agent_flag po_requisition_lines_all.modified_by_agent_flag%type default NULL /*Added for Bug 8241905*/
377: , p_parent_req_line_id po_requisition_lines_all.parent_req_line_id%type default NULL /*Added for Bug 8241905*/
378: , p_max_tax_line NUMBER DEFAULT 0 /*Added for Bug 8371741*/
379: , p_max_rgm_tax_line NUMBER DEFAULT 0 /*Added for Bug 8371741*/
380: --, pn_gst_assessable_value NUMBER DEFAULT 0 -- Added by Jia for GST Bug#10043656 on 2010/09/10
381: , pn_customs_assessable_value NUMBER DEFAULT 0 --Added by Bo Li for Bug#11684111 BOE Ehancement

Line 3924: FROM Po_Requisition_Lines_All

3920: CURSOR fetch_vendor2_cur IS
3921: SELECT vendor_id
3922: FROM JAI_PO_REQ_LINE_TAXES
3923: WHERE Requisition_Line_Id = ( SELECT Requisition_Line_Id
3924: FROM Po_Requisition_Lines_All
3925: WHERE Line_Location_Id = p_line_id );
3926:
3927: CURSOR fetch_focus_id IS
3928: SELECT Line_Focus_Id