APPS.JAI_BOE_MIGRATION_PKG dependencies on JAI_CMN_BOE_HDRS

Line 131: lv_boe_invoice_num jai_cmn_boe_hdrs.INVOICE_NUM%TYPE;

127: ln_available_amount NUMBER;
128: lv_consolidate_flag VARCHAR2(1);
129: ln_percentage NUMBER := 0;
130: lv_valid_category_flag VARCHAR2(1);
131: lv_boe_invoice_num jai_cmn_boe_hdrs.INVOICE_NUM%TYPE;
132:
133: CURSOR boe_hdr_cur(pn_boe_id NUMBER) IS
134: SELECT BOE_AMOUNT
135: ,AMOUNT_APPLIED

Line 139: FROM jai_cmn_boe_hdrs_all

135: ,AMOUNT_APPLIED
136: ,AMOUNT_WRITTEN_OFF
137: ,INVOICE_NUM,
138: CONSOLIDATED_FLAG
139: FROM jai_cmn_boe_hdrs_all
140: WHERE boe_id = pn_boe_id;
141:
142: boe_hdr_rec boe_hdr_cur%ROWTYPE;
143:

Line 250: boe_status jai_cmn_boe_hdrs.status%TYPE;

246: FROM AP_INVOICES
247: WHERE INVOICE_NUM = pn_invoice_num;
248:
249: boe_invoice_payment_status AP_INVOICES.PAYMENT_STATUS_FLAG%TYPE;
250: boe_status jai_cmn_boe_hdrs.status%TYPE;
251:
252: BEGIN
253: Fnd_File.put_line(Fnd_File.LOG,' **Start update_boe_hdr for boe_id:' || pn_boe_id ||' invoice num:' || pv_invoice_num ||'applied amount:' || pn_amount_applied || ' **');
254:

Line 267: UPDATE jai_cmn_boe_hdrs_all SET

263: ELSIF nvl(boe_invoice_payment_status,'N') = 'Y' AND nvl(pn_amount_applied,0) > 0 THEN
264: boe_status := 'APPLIED';
265: END IF;--nvl(boe_invoice_payment_status ,'N') = 'N'
266:
267: UPDATE jai_cmn_boe_hdrs_all SET
268: status = boe_status,
269: migration_flag = 'Y',
270: org_id = pn_org_id,
271: BOE_WITHOUT_REFER_FLAG = decode(CONSOLIDATED_FLAG,'Y',NULL,'N','Y'),

Line 1128: FROM JAI_CMN_BOE_HDRS_ALL hdr,

1124: hdr.AMOUNT_WRITTEN_OFF,
1125: hdr.status,
1126: hdr.migration_flag,
1127: OU.ORGANIZATION_ID OU_ID
1128: FROM JAI_CMN_BOE_HDRS_ALL hdr,
1129: org_organization_definitions INV,
1130: hr_all_organization_units OU
1131: WHERE INV.operating_unit = OU.organization_id
1132: AND INV.organization_id = hdr.organization_id

Line 1429: jai_cmn_boe_hdrs_all hdr

1425: SELECT org.boe_account_id boe_account,
1426: hdr.organization_id,
1427: hdr.location_id
1428: FROM JAI_CMN_INVENTORY_ORGS org,
1429: jai_cmn_boe_hdrs_all hdr
1430: WHERE org.organization_id = hdr.organization_id
1431: AND org.location_id = hdr.location_id
1432: AND hdr.boe_id = v_boe_id;
1433: