APPS.OZF_SD_BATCH_PVT dependencies on OZF_SUPP_TRD_PRFLS_ALL

Line 184: FROM OZF_SUPP_CODE_CONVERSIONS_ALL code, OZF_SUPP_TRD_PRFLS_ALL prf

180: l_internal_code := p_product_id;
181:
182: SELECT code.external_code
183: INTO l_vendor_product_id
184: FROM OZF_SUPP_CODE_CONVERSIONS_ALL code, OZF_SUPP_TRD_PRFLS_ALL prf
185: WHERE internal_code = l_internal_code and
186: code.supp_trade_profile_id = prf.supp_trade_profile_id and
187: prf.supplier_site_id = p_supplier_site_id and
188: trunc(sysdate) between code.start_date_active and

Line 476: ozf_supp_trd_prfls_all trprf

472: --org id Code added for bug#6867618
473: CURSOR get_sites(c_vendor_id NUMBER,c_org_id NUMBER) IS
474: SELECT sites.vendor_site_id
475: FROM ap_supplier_sites_all sites,
476: ozf_supp_trd_prfls_all trprf
477: WHERE sites.vendor_id = c_vendor_id AND
478: sites.org_id = c_org_id AND
479: nvl(sites.inactive_date, sysdate) >= trunc(sysdate) AND
480: trprf.cust_account_id is not null AND

Line 486: FROM ozf_supp_trd_prfls_all

482: sites.vendor_site_id=trprf.supplier_site_id;
483:
484: CURSOR trade_profile_values(c_supplier_site_id NUMBER,c_org_id NUMBER) IS
485: SELECT claim_currency_code
486: FROM ozf_supp_trd_prfls_all
487: WHERE supplier_site_id = c_supplier_site_id AND
488: org_id = c_org_id;
489:
490: CURSOR get_freq_and_date(c_supplier_site_id NUMBER,c_org_id NUMBER) IS

Line 492: FROM ozf_supp_trd_prfls_all

488: org_id = c_org_id;
489:
490: CURSOR get_freq_and_date(c_supplier_site_id NUMBER,c_org_id NUMBER) IS
491: SELECT claim_frequency, claim_frequency_unit, last_paid_date
492: FROM ozf_supp_trd_prfls_all
493: WHERE supplier_site_id = c_supplier_site_id AND
494: org_id = c_org_id;
495:
496: BEGIN

Line 556: l_query := 'SELECT claim_currency_code FROM OZF_SUPP_TRD_PRFLS_ALL ' ||

552: l_query := 'SELECT distinct request_currency_code FROM OZF_SD_REQUEST_HEADERS_ALL_B ' ||
553: ' WHERE supplier_id=' || p_supplier_id ||
554: ' AND supplier_site_id=' || p_supplier_site_id;
555: ELSE
556: l_query := 'SELECT claim_currency_code FROM OZF_SUPP_TRD_PRFLS_ALL ' ||
557: ' WHERE supplier_site_id =' || p_supplier_site_id;
558:
559: END IF;
560:

Line 656: UPDATE ozf_supp_trd_prfls_all

652: CLOSE c_currency;
653: -- after currency loop
654: -- IF l_empty_batch = 'N' THEN
655:
656: UPDATE ozf_supp_trd_prfls_all
657: SET last_paid_date = sysdate
658: WHERE supplier_site_id = l_supplier_site_id;
659:
660: IF fnd_api.To_Boolean(p_commit) THEN

Line 704: l_query := 'SELECT claim_currency_code FROM OZF_SUPP_TRD_PRFLS_ALL ' ||

700: --Code added for bug#6867618
701: l_query := 'SELECT distinct request_currency_code FROM OZF_SD_REQUEST_HEADERS_ALL_B ' ||
702: ' WHERE supplier_site_id=' || site_rec.vendor_site_id;
703: ELSE
704: l_query := 'SELECT claim_currency_code FROM OZF_SUPP_TRD_PRFLS_ALL ' ||
705: ' WHERE supplier_site_id =' || site_rec.vendor_site_id;
706:
707: END IF;
708:

Line 791: UPDATE ozf_supp_trd_prfls_all

787: END IF;
788:
789: END LOOP;
790:
791: UPDATE ozf_supp_trd_prfls_all
792: SET last_paid_date = sysdate
793: WHERE supplier_site_id = l_supplier_site_id;
794:
795: IF fnd_api.To_Boolean(p_commit) THEN

Line 877: FROM ozf_supp_trd_prfls_all

873: p_attribute15 IN VARCHAR2 := NULL) is
874:
875: CURSOR trade_profile_values(c_supplier_site_id NUMBER) IS
876: SELECT min_claim_amt, min_claim_amt_line_lvl, auto_debit
877: FROM ozf_supp_trd_prfls_all
878: WHERE supplier_site_id = c_supplier_site_id;
879:
880: l_batch_id NUMBER;
881: l_empty_batch VARCHAR2(15) := 'Y';

Line 2086: FROM ozf_supp_trd_prfls_all

2082: p_vendor_site_id NUMBER) is
2083:
2084: CURSOR get_freq_and_date(c_supplier_site_id NUMBER) IS
2085: SELECT days_before_claiming_debit
2086: FROM ozf_supp_trd_prfls_all
2087: WHERE supplier_site_id = c_supplier_site_id;
2088:
2089: l_claim_id NUMBER := NULL; -- Incase auto claim is run
2090: l_claim_ret_status VARCHAR2(15) := NULL;