APPS.JAI_AP_UTILS_PKG dependencies on JAI_CMN_BOE_HDRS

Line 403: FROM jai_cmn_boe_hdrs

399: GROUP BY jct.tax_type;
400:
401: CURSOR get_import_date_cur(pn_boe_id NUMBER) IS
402: SELECT import_date, organization_id, location_id,depb_amount
403: FROM jai_cmn_boe_hdrs
404: WHERE boe_id = pn_boe_id;
405:
406: get_tax_amount_rec get_tax_amount_cur%ROWTYPE;
407: ld_import_date DATE;

Line 445: Included logic to populate the invoice_num field in jai_cmn_boe_hdrs.

441: 5 10/04/2007 bduvarag for bug#5607160,File version 120.9
442: Forward porting the changes done in 11i bug#5591827
443:
444: 6 09-JAN-2009 Bug 6503442 (FP for bug 6282935) - File version 120.22
445: Included logic to populate the invoice_num field in jai_cmn_boe_hdrs.
446: This fix involves the addition of new column in jai_cmn_boe_hdrs, and will
447: be a dependency for all future fixes.
448:
449: -------------------------------------------------------------------------------------------------------------------*/

Line 446: This fix involves the addition of new column in jai_cmn_boe_hdrs, and will

442: Forward porting the changes done in 11i bug#5591827
443:
444: 6 09-JAN-2009 Bug 6503442 (FP for bug 6282935) - File version 120.22
445: Included logic to populate the invoice_num field in jai_cmn_boe_hdrs.
446: This fix involves the addition of new column in jai_cmn_boe_hdrs, and will
447: be a dependency for all future fixes.
448:
449: -------------------------------------------------------------------------------------------------------------------*/
450:

Line 572: 'JAI_CMN_BOE_HDRS',

568: trunc(jibh.last_update_date)
569: -- Added by Wenqiong Zhou for Bug #1168411 BOE enhancement Begin
570: ,
571: 7000,
572: 'JAI_CMN_BOE_HDRS',
573: jibh.boe_id,
574: NULL,
575: NULL,
576: NULL,

Line 580: JAI_CMN_BOE_HDRS jibh,

576: NULL,
577: NULL
578: -- Added by Wenqiong Zhou for Bug #1168411 BOE enhancement End
579: FROM
580: JAI_CMN_BOE_HDRS jibh,
581: po_vendors pv,
582: po_vendor_sites_all pvs
583: where jibh.boe_id = p_boe_id
584: and pvs.vendor_site_id (+)= jibh.vendor_site_id

Line 590: UPDATE jai_cmn_boe_hdrs

586: and nvl(pvs.org_id, 0) = nvl(v_org_id, 0);
587:
588: /*bug 6503442 - FP of bug 6282935*/
589: /* Comment out by Qiong Liu for Bug#12400670 begin
590: UPDATE jai_cmn_boe_hdrs
591: SET invoice_num = for_invoice_num_rec.inv_num
592: WHERE boe_id = p_boe_id;
593: Comment out by Qiong Liu for Bug#12400670 end */
594: /*end bug 6503442*/

Line 599: from JAI_CMN_BOE_HDRS jibh,

595:
596: /* Comment out by Wenqiong Zhou for Bug #1168411 BOE enhancement Begin
597: select count(*)
598: into cnt_rec
599: from JAI_CMN_BOE_HDRS jibh,
600: JAI_CMN_INVENTORY_ORGS org
601: where jibh.boe_id = p_boe_id
602: and org.organization_id = jibh.organization_id
603: and org.location_id = jibh.location_id;

Line 648: from JAI_CMN_BOE_HDRS jibh,

644: trunc(jibh.creation_date),
645: jibh.last_updated_by,
646: jibh.last_update_date,
647: null -- last_update_login
648: from JAI_CMN_BOE_HDRS jibh,
649: JAI_CMN_INVENTORY_ORGS org
650: where jibh.boe_id = p_boe_id
651: and org.organization_id = jibh.organization_id
652: AND org.location_id = 0 ;

Line 694: JAI_CMN_BOE_HDRS jibh,

690: jibh.last_updated_by,
691: jibh.last_update_date,
692: null -- last_update_login
693: from
694: JAI_CMN_BOE_HDRS jibh,
695: JAI_CMN_INVENTORY_ORGS org
696: where
697: jibh.boe_id = p_boe_id
698: and org.organization_id = jibh.organization_id