[Home] [Help]
1: PACKAGE BODY AHL_WARRANTY_CONTRACTS_PVT AS
2: /* $Header: AHLVSWCB.pls 120.10.12020000.3 2013/05/29 04:27:18 sareepar ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_WARRANTY_CONTRACTS_PVT';
5:
1: PACKAGE BODY AHL_WARRANTY_CONTRACTS_PVT AS
2: /* $Header: AHLVSWCB.pls 120.10.12020000.3 2013/05/29 04:27:18 sareepar ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_WARRANTY_CONTRACTS_PVT';
5:
6: ------------------------------------
7: -- Common constants and variables --
8: ------------------------------------
59: AND TRUNC(NVL(INSTANCE.ACTIVE_START_DATE, SYSDATE)) <= TRUNC(SYSDATE)
60: AND TRUNC(NVL(INSTANCE.ACTIVE_END_DATE, SYSDATE+1)) > TRUNC(SYSDATE)
61: -- avikukum :: changes for bug# 11664006 :: END
62: AND ASSOC.AUTO_ASSIGN_FLAG = 'Y'
63: AND AHL_WARRANTY_CONTRACTS_PVT.Can_Contract_Be_Created -- utility function defined in this package
64: (
65: ASSOC.WARRANTY_TEMPLATE_ID,
66: ASSOC.INVENTORY_ITEM_ID,
67: ASSOC.INVENTORY_ORG_ID
126: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
127:
128: -- NOTE: p_init_msg_list, p_commit and p_validation_level will take their default values, and
129: -- commit will take place only after all the contracts have been created
130: AHL_WARRANTY_CONTRACTS_PVT.Create_Contract (
131: p_warranty_template_id => auto_create_details_rec.WARRANTY_TEMPLATE_ID,
132: p_item_instance_id => auto_create_details_rec.INSTANCE_ID,
133: p_api_version => l_api_version,
134: x_warranty_contract_id => l_warranty_contract_id,
1028: where T.WARRANTY_CNTRT_COUNTER_ID = B.WARRANTY_CNTRT_COUNTER_ID
1029: and T.LANGUAGE = L.LANGUAGE_CODE);
1030: END ADD_LANGUAGE;
1031:
1032: END AHL_WARRANTY_CONTRACTS_PVT;