[Home] [Help]
596: /*5694855..start* kunkumar for forward porting to R12*/
597: CURSOR cur_fetch_io IS
598: SELECT ship_to_organization_id,
599: ship_to_location_id
600: FROM po_line_locations_all
601: WHERE line_location_id IN ( SELECT line_location_id
602: FROM po_distributions_all
603: WHERE po_distribution_id = po_dist_id) ;
604:
3112: AND vendor_site_id = ven_site_id
3113: AND NVL(org_id, -1) = NVL(v_org_id, -1);
3114:
3115: /*below cursor added for bug 6595773*/
3116: cursor c_get_ship_to_org_loc (cpn_line_location_id po_line_locations_all.line_location_id%type)
3117: is
3118: select ship_to_organization_id
3119: ,ship_to_location_id
3120: from po_line_locations_all plla
3116: cursor c_get_ship_to_org_loc (cpn_line_location_id po_line_locations_all.line_location_id%type)
3117: is
3118: select ship_to_organization_id
3119: ,ship_to_location_id
3120: from po_line_locations_all plla
3121: where plla.line_location_id = cpn_line_location_id;
3122:
3123:
3124: -- Cursor modified to use pn_invoice_line_number instead of distribution_line_number, bug#4445989
3608: v_tax_amount_liability NUMBER;
3609: for_org_id_rec for_org_id%ROWTYPE;
3610: v_apportn_factor_for_item_line NUMBER; -- Bug#3752887
3611: v_apportn_factor_for_adhoc NUMBER; --Added by nprashar for bug # 13363329
3612: ln_ship_to_organization_id po_line_locations_all.ship_to_organization_id%type;
3613: ln_ship_to_location_id po_line_locations_all.ship_to_location_id%type;
3614:
3615:
3616: /* 5763527 , Project costing Fwd porting*/
3609: for_org_id_rec for_org_id%ROWTYPE;
3610: v_apportn_factor_for_item_line NUMBER; -- Bug#3752887
3611: v_apportn_factor_for_adhoc NUMBER; --Added by nprashar for bug # 13363329
3612: ln_ship_to_organization_id po_line_locations_all.ship_to_organization_id%type;
3613: ln_ship_to_location_id po_line_locations_all.ship_to_location_id%type;
3614:
3615:
3616: /* 5763527 , Project costing Fwd porting*/
3617: ln_project_id ap_invoice_distributions_all.project_id%TYPE;
5637: select precision
5638: from fnd_currencies
5639: where currency_code = cp_currency_code;
5640:
5641: cursor c_get_ship_to_org_loc (cpn_line_location_id po_line_locations_all.line_location_id%type)
5642: is
5643: select ship_to_organization_id
5644: ,ship_to_location_id
5645: from po_line_locations_all plla
5641: cursor c_get_ship_to_org_loc (cpn_line_location_id po_line_locations_all.line_location_id%type)
5642: is
5643: select ship_to_organization_id
5644: ,ship_to_location_id
5645: from po_line_locations_all plla
5646: where plla.line_location_id = cpn_line_location_id;
5647:
5648: ln_precision fnd_currencies.precision%type; -- added by sssumaith - bug# 3127834
5649: v_statement_no VARCHAR2(6);
5711: lv_tax_type varchar2(5);
5712: lv_tax_line_amount NUMBER := 0;
5713: lv_ap_line_to_inst_flag VARCHAR2(1);
5714: lv_tax_line_to_inst_flag VARCHAR2(1);
5715: ln_ship_to_organization_id po_line_locations_all.ship_to_organization_id%type;
5716: ln_ship_to_location_id po_line_locations_all.ship_to_location_id%type;
5717:
5718: /* Service Tax */
5719: cursor c_rcv_transactions(p_transaction_id number) is
5712: lv_tax_line_amount NUMBER := 0;
5713: lv_ap_line_to_inst_flag VARCHAR2(1);
5714: lv_tax_line_to_inst_flag VARCHAR2(1);
5715: ln_ship_to_organization_id po_line_locations_all.ship_to_organization_id%type;
5716: ln_ship_to_location_id po_line_locations_all.ship_to_location_id%type;
5717:
5718: /* Service Tax */
5719: cursor c_rcv_transactions(p_transaction_id number) is
5720: select po_line_id, organization_id
6499:
6500: ELSIF rcv_tran_id IS NULL and v_source IN ('ERS', 'ASBN', 'RTS') THEN
6501:
6502: --IF rcv_tran_id IS NOT NULL THEN
6503: -- to be fired when po_line_locations_all.match_option = 'P'
6504:
6505: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX || '.' || l_api_name, 'Fired when rcv_tran_id IS NULL, match_option is P');
6506:
6507: -- fetch shipment_num from rcv_headers_interface based on invoice_num