17: -- Pre-Req :
18: -- Parameters:
19: -- IN:
20: -- p_api_version_number IN NUMBER Required
21: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
22: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
23: -- p_validation_level IN NUMBER Optional Default =
24: -- FND_API.G_VALID_LEVEL_FULL
25: -- p_lead_id IN NUMBER,
18: -- Parameters:
19: -- IN:
20: -- p_api_version_number IN NUMBER Required
21: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
22: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
23: -- p_validation_level IN NUMBER Optional Default =
24: -- FND_API.G_VALID_LEVEL_FULL
25: -- p_lead_id IN NUMBER,
26: -- OUT:
20: -- p_api_version_number IN NUMBER Required
21: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
22: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
23: -- p_validation_level IN NUMBER Optional Default =
24: -- FND_API.G_VALID_LEVEL_FULL
25: -- p_lead_id IN NUMBER,
26: -- OUT:
27: -- x_return_status OUT VARCHAR2
28: -- x_msg_count OUT NUMBER
32: -- End of Comments
33:
34: PROCEDURE RECONCILE_SALESCREDIT(
35: p_api_version_number IN NUMBER,
36: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
37: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
38: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
39: p_lead_id IN NUMBER,
40: X_Return_Status OUT NOCOPY VARCHAR2,
33:
34: PROCEDURE RECONCILE_SALESCREDIT(
35: p_api_version_number IN NUMBER,
36: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
37: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
38: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
39: p_lead_id IN NUMBER,
40: X_Return_Status OUT NOCOPY VARCHAR2,
41: X_Msg_Count OUT NOCOPY NUMBER,
34: PROCEDURE RECONCILE_SALESCREDIT(
35: p_api_version_number IN NUMBER,
36: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
37: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
38: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
39: p_lead_id IN NUMBER,
40: X_Return_Status OUT NOCOPY VARCHAR2,
41: X_Msg_Count OUT NOCOPY NUMBER,
42: X_Msg_Data OUT NOCOPY VARCHAR2
43: );
44:
45: PROCEDURE CHECK_SALES_STAGE(
46: p_api_version_number IN NUMBER,
47: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
48: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
49: p_sales_lead_id IN NUMBER,
50: X_sales_stage_id OUT NOCOPY NUMBER,
51: X_sales_methodology_id OUT NOCOPY NUMBER,
44:
45: PROCEDURE CHECK_SALES_STAGE(
46: p_api_version_number IN NUMBER,
47: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
48: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
49: p_sales_lead_id IN NUMBER,
50: X_sales_stage_id OUT NOCOPY NUMBER,
51: X_sales_methodology_id OUT NOCOPY NUMBER,
52: X_Return_Status OUT NOCOPY VARCHAR2,
54: X_Msg_Data OUT NOCOPY VARCHAR2);
55:
56: PROCEDURE RECONCILE_SALESMETHODOLOGY(
57: p_api_version_number IN NUMBER,
58: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
59: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
60: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
61: p_lead_id IN NUMBER,
62: p_sales_stage_id IN NUMBER,
55:
56: PROCEDURE RECONCILE_SALESMETHODOLOGY(
57: p_api_version_number IN NUMBER,
58: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
59: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
60: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
61: p_lead_id IN NUMBER,
62: p_sales_stage_id IN NUMBER,
63: p_sales_methodology_id IN NUMBER,
56: PROCEDURE RECONCILE_SALESMETHODOLOGY(
57: p_api_version_number IN NUMBER,
58: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
59: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
60: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
61: p_lead_id IN NUMBER,
62: p_sales_stage_id IN NUMBER,
63: p_sales_methodology_id IN NUMBER,
64: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
60: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
61: p_lead_id IN NUMBER,
62: p_sales_stage_id IN NUMBER,
63: p_sales_methodology_id IN NUMBER,
64: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
65: P_Admin_Group_Id IN NUMBER,
66: P_Identity_Salesforce_Id IN NUMBER := NULL,
67: P_identity_salesgroup_id IN NUMBER := NULL,
68: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,