APPS.ONT_OEXOECCH_XMLP_PKG dependencies on OE_CREDIT_CHECK_RULES

Line 378: OE_CREDIT_CHECK_RULES

374: SELECT
375: INCLUDE_PAYMENTS_AT_RISK_FLAG
376: INTO L_INCLUDE_RISK_FLAG1
377: FROM
378: OE_CREDIT_CHECK_RULES
379: WHERE CREDIT_CHECK_RULE_ID = ENTRY_RULE_ID;
380: END IF;
381: IF SHIP_RULE_ID <> -1 THEN
382: DEBUG := 4;

Line 387: OE_CREDIT_CHECK_RULES

383: SELECT
384: INCLUDE_PAYMENTS_AT_RISK_FLAG
385: INTO L_INCLUDE_RISK_FLAG2
386: FROM
387: OE_CREDIT_CHECK_RULES
388: WHERE CREDIT_CHECK_RULE_ID = SHIP_RULE_ID;
389: END IF;
390: IF PICK_RULE_ID <> -1 AND PICK_RULE_ID IS NOT NULL THEN
391: DEBUG := 45;

Line 396: OE_CREDIT_CHECK_RULES

392: SELECT
393: INCLUDE_PAYMENTS_AT_RISK_FLAG
394: INTO L_INCLUDE_RISK_FLAG3
395: FROM
396: OE_CREDIT_CHECK_RULES
397: WHERE CREDIT_CHECK_RULE_ID = PICK_RULE_ID;
398: END IF;
399: IF PACK_RULE_ID <> -1 AND PACK_RULE_ID IS NOT NULL THEN
400: DEBUG := 46;

Line 405: OE_CREDIT_CHECK_RULES

401: SELECT
402: INCLUDE_PAYMENTS_AT_RISK_FLAG
403: INTO L_INCLUDE_RISK_FLAG4
404: FROM
405: OE_CREDIT_CHECK_RULES
406: WHERE CREDIT_CHECK_RULE_ID = PACK_RULE_ID;
407: END IF;
408: END IF;
409: IF SITE_USE_ID = 0 THEN