DBA Data[Home] [Help]

APPS.RLM_SHIP_DELIVERY_PATTERN_SV dependencies on RLM_CUST_SHIPTO_TERMS

Line 801: use_edi_sdp_code_flag IN rlm_cust_shipto_terms.use_edi_sdp_code_flag%TYPE,

797: ==============================================================================*/
798:
799: PROCEDURE determine_sdp_code(
800: ShipDeliveryRuleName IN VARCHAR2,
801: use_edi_sdp_code_flag IN rlm_cust_shipto_terms.use_edi_sdp_code_flag%TYPE,
802: DefaultSDP IN rlm_cust_shipto_terms.ship_delivery_rule_name%TYPE,
803: x_customer_id IN NUMBER,
804: x_shipFromOrg IN NUMBER,
805: x_shipTo IN NUMBER,

Line 802: DefaultSDP IN rlm_cust_shipto_terms.ship_delivery_rule_name%TYPE,

798:
799: PROCEDURE determine_sdp_code(
800: ShipDeliveryRuleName IN VARCHAR2,
801: use_edi_sdp_code_flag IN rlm_cust_shipto_terms.use_edi_sdp_code_flag%TYPE,
802: DefaultSDP IN rlm_cust_shipto_terms.ship_delivery_rule_name%TYPE,
803: x_customer_id IN NUMBER,
804: x_shipFromOrg IN NUMBER,
805: x_shipTo IN NUMBER,
806: x_ReturnMessage IN OUT NOCOPY t_ErrorMsgTable,

Line 1041: FROM RLM_CUST_SHIPTO_TERMS_ALL

1037: IF (v_SdpCode IS NULL) THEN
1038: --
1039: SELECT ship_delivery_rule_name
1040: INTO v_SdpCode
1041: FROM RLM_CUST_SHIPTO_TERMS_ALL
1042: WHERE ship_from_org_id = x_ShipFromOrgId
1043: AND address_id = x_ShipToAddressId;
1044: --
1045: END IF;

Line 1178: FROM RLM_CUST_SHIPTO_TERMS_ALL

1174: IF (v_ShipMethod IS NULL) THEN
1175: --
1176: SELECT ship_method
1177: INTO v_ShipMethod
1178: FROM RLM_CUST_SHIPTO_TERMS_ALL
1179: WHERE ship_from_org_id = x_ShipFromOrgId AND
1180: address_id = x_ShipToAddressId;
1181: --
1182: IF (l_debug <> -1) THEN