27: )RETURN VARCHAR2;
28:
29: PROCEDURE RECORD_IS_LOCKED_MSG(P_TOKEN_AN IN VARCHAR2);
30:
31: PROCEDURE TO_NULL(p_cost_rec_in IN cs_cost_details_pub.Cost_Rec_Type,
32: p_cost_rec_out OUT NOCOPY cs_cost_details_pub.Cost_Rec_Type
33: );
34:
35: PROCEDURE VALIDATE_COST_DETAILS
28:
29: PROCEDURE RECORD_IS_LOCKED_MSG(P_TOKEN_AN IN VARCHAR2);
30:
31: PROCEDURE TO_NULL(p_cost_rec_in IN cs_cost_details_pub.Cost_Rec_Type,
32: p_cost_rec_out OUT NOCOPY cs_cost_details_pub.Cost_Rec_Type
33: );
34:
35: PROCEDURE VALIDATE_COST_DETAILS
36: (
34:
35: PROCEDURE VALIDATE_COST_DETAILS
36: (
37: p_api_name IN VARCHAR2,
38: pv_cost_rec IN CS_COST_DETAILS_PUB.COST_REC_TYPE,
39: p_validation_mode IN VARCHAR2,
40: p_user_id IN NUMBER,
41: p_login_id IN NUMBER,
42: x_cost_rec OUT NOCOPY CS_COST_DETAILS_PUB.COST_REC_TYPE,
38: pv_cost_rec IN CS_COST_DETAILS_PUB.COST_REC_TYPE,
39: p_validation_mode IN VARCHAR2,
40: p_user_id IN NUMBER,
41: p_login_id IN NUMBER,
42: x_cost_rec OUT NOCOPY CS_COST_DETAILS_PUB.COST_REC_TYPE,
43: x_msg_data OUT NOCOPY VARCHAR2,
44: x_msg_count OUT NOCOPY NUMBER,
45: x_return_status OUT NOCOPY VARCHAR2
46: );
1370: p_resp_id IN NUMBER := FND_GLOBAL.RESP_ID,
1371: p_user_id IN NUMBER := FND_GLOBAL.USER_ID,
1372: p_login_id IN NUMBER := FND_GLOBAL.LOGIN_ID,
1373: p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
1374: p_cost_rec IN CS_Cost_Details_PUB.Cost_Rec_Type,
1375: p_cost_creation_override IN VARCHAR2:='N'
1376: ) IS
1377:
1378:
1381: l_api_name_full CONSTANT VARCHAR2(100) := G_PKG_NAME || '.' || l_api_name ;
1382: l_prog_name CONSTANT VARCHAR2(100) := G_PKG_NAME||'.'||'create_cost_details';
1383: l_log_module CONSTANT VARCHAR2(255) := 'csxvcsts.pls.' || l_api_name_full || '.';
1384:
1385: l_cost_rec CS_Cost_Details_PUB.Cost_Rec_Type;
1386: lx_cost_rec CS_Cost_Details_PUB.Cost_Rec_Type;
1387:
1388: l_valid_check VARCHAR2(1);
1389: l_return_status VARCHAR2(1) ;
1382: l_prog_name CONSTANT VARCHAR2(100) := G_PKG_NAME||'.'||'create_cost_details';
1383: l_log_module CONSTANT VARCHAR2(255) := 'csxvcsts.pls.' || l_api_name_full || '.';
1384:
1385: l_cost_rec CS_Cost_Details_PUB.Cost_Rec_Type;
1386: lx_cost_rec CS_Cost_Details_PUB.Cost_Rec_Type;
1387:
1388: l_valid_check VARCHAR2(1);
1389: l_return_status VARCHAR2(1) ;
1390: l_msg_data VARCHAR2(2000);
1508: );
1509: -- --------------------------------------------------------------------------
1510: -- This procedure Logs the charges record paramters.
1511: -- --------------------------------------------------------------------------
1512: CS_COST_DETAILS_PUB.Log_Cost_Rec_Parameters
1513: ( p_cost_Rec_in => p_cost_rec
1514: );
1515:
1516: END IF;
2109: p_resp_id IN NUMBER := FND_GLOBAL.RESP_ID,
2110: p_user_id IN NUMBER := FND_GLOBAL.USER_ID,
2111: p_login_id IN NUMBER :=FND_GLOBAL.LOGIN_ID,
2112: p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
2113: p_Cost_Rec IN CS_Cost_Details_PUB.Cost_Rec_Type
2114:
2115: ) IS
2116:
2117: l_api_version NUMBER := 1.0 ;
2120: l_log_module CONSTANT VARCHAR2(255) := 'csxvcstb.pls.' || l_api_name_full || '.';
2121: l_return_status VARCHAR2(1) ;
2122: l_org_id NUMBER ;
2123: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'update_cost_details';
2124: l_cost_rec CS_Cost_Details_PUB.Cost_Rec_Type;
2125: lx_cost_rec CS_Cost_Details_PUB.Cost_Rec_Type;
2126: l_valid_check VARCHAR2(1);
2127:
2128: l_msg_data VARCHAR2(2000);
2121: l_return_status VARCHAR2(1) ;
2122: l_org_id NUMBER ;
2123: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'update_cost_details';
2124: l_cost_rec CS_Cost_Details_PUB.Cost_Rec_Type;
2125: lx_cost_rec CS_Cost_Details_PUB.Cost_Rec_Type;
2126: l_valid_check VARCHAR2(1);
2127:
2128: l_msg_data VARCHAR2(2000);
2129: l_msg_count NUMBER;
2241: );
2242: -- --------------------------------------------------------------------------
2243: -- This procedure Logs the charges record paramters.
2244: -- --------------------------------------------------------------------------
2245: CS_COST_DETAILS_PUB.Log_Cost_Rec_Parameters
2246: ( p_cost_Rec_in => p_cost_rec
2247: );
2248:
2249: END IF;
2987:
2988: PROCEDURE VALIDATE_COST_DETAILS
2989: (
2990: p_api_name IN VARCHAR2,
2991: pv_cost_rec IN CS_COST_DETAILS_PUB.COST_REC_TYPE,
2992: p_validation_mode IN VARCHAR2,
2993: p_user_id IN NUMBER,
2994: p_login_id IN NUMBER,
2995: x_cost_rec OUT NOCOPY CS_COST_DETAILS_PUB.COST_REC_TYPE,
2991: pv_cost_rec IN CS_COST_DETAILS_PUB.COST_REC_TYPE,
2992: p_validation_mode IN VARCHAR2,
2993: p_user_id IN NUMBER,
2994: p_login_id IN NUMBER,
2995: x_cost_rec OUT NOCOPY CS_COST_DETAILS_PUB.COST_REC_TYPE,
2996: x_msg_data OUT NOCOPY VARCHAR2,
2997: x_msg_count OUT NOCOPY NUMBER,
2998: x_return_status OUT NOCOPY VARCHAR2
2999: ) IS
4367: /**************************************************
4368: Private Procedure Body TO_NULL
4369: **************************************************/
4370:
4371: PROCEDURE TO_NULL(p_cost_rec_in IN cs_cost_details_pub.Cost_Rec_Type,
4372: p_cost_rec_out OUT NOCOPY cs_cost_details_pub.Cost_Rec_Type) IS
4373: BEGIN
4374: p_cost_rec_out.cost_id := Check_For_Miss(p_cost_rec_in.cost_id) ;
4375: p_cost_rec_out.incident_id := Check_For_Miss(p_cost_rec_in.incident_id) ;
4368: Private Procedure Body TO_NULL
4369: **************************************************/
4370:
4371: PROCEDURE TO_NULL(p_cost_rec_in IN cs_cost_details_pub.Cost_Rec_Type,
4372: p_cost_rec_out OUT NOCOPY cs_cost_details_pub.Cost_Rec_Type) IS
4373: BEGIN
4374: p_cost_rec_out.cost_id := Check_For_Miss(p_cost_rec_in.cost_id) ;
4375: p_cost_rec_out.incident_id := Check_For_Miss(p_cost_rec_in.incident_id) ;
4376: p_cost_rec_out.estimate_Detail_id := Check_For_Miss(p_cost_rec_in.estimate_Detail_id) ;