DBA Data[Home] [Help]

APPS.AS_DECISION_FACTOR_PVT dependencies on AS_OPPORTUNITY_PUB

Line 29: P_decision_factor_Tbl IN As_Opportunity_Pub.Decision_Factor_Tbl_Type :=

25: P_Identity_Salesforce_Id IN NUMBER := NULL,
26:
27: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
28: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
29: P_decision_factor_Tbl IN As_Opportunity_Pub.Decision_Factor_Tbl_Type :=
30: AS_OPPORTUNITY_PUB.G_MISS_decision_factor_Tbl,
31: X_decision_factor_out_tbl OUT NOCOPY as_opportunity_pub.decision_factor_out_tbl_type,
32: X_Return_Status OUT NOCOPY VARCHAR2,
33: X_Msg_Count OUT NOCOPY NUMBER,

Line 30: AS_OPPORTUNITY_PUB.G_MISS_decision_factor_Tbl,

26:
27: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
28: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
29: P_decision_factor_Tbl IN As_Opportunity_Pub.Decision_Factor_Tbl_Type :=
30: AS_OPPORTUNITY_PUB.G_MISS_decision_factor_Tbl,
31: X_decision_factor_out_tbl OUT NOCOPY as_opportunity_pub.decision_factor_out_tbl_type,
32: X_Return_Status OUT NOCOPY VARCHAR2,
33: X_Msg_Count OUT NOCOPY NUMBER,
34: X_Msg_Data OUT NOCOPY VARCHAR2

Line 31: X_decision_factor_out_tbl OUT NOCOPY as_opportunity_pub.decision_factor_out_tbl_type,

27: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
28: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
29: P_decision_factor_Tbl IN As_Opportunity_Pub.Decision_Factor_Tbl_Type :=
30: AS_OPPORTUNITY_PUB.G_MISS_decision_factor_Tbl,
31: X_decision_factor_out_tbl OUT NOCOPY as_opportunity_pub.decision_factor_out_tbl_type,
32: X_Return_Status OUT NOCOPY VARCHAR2,
33: X_Msg_Count OUT NOCOPY NUMBER,
34: X_Msg_Data OUT NOCOPY VARCHAR2
35: )

Line 48: --P_Decision_Factor_Rec AS_OPPORTUNITY_PUB.Decision_Factor_Rec_Type;

44: l_api_version_number CONSTANT NUMBER := 2.0;
45: l_return_status_full VARCHAR2(1);
46: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
47: l_access_flag VARCHAR2(1);
48: --P_Decision_Factor_Rec AS_OPPORTUNITY_PUB.Decision_Factor_Rec_Type;
49: l_decision_factor_rec AS_OPPORTUNITY_PUB.Decision_Factor_Rec_Type;
50: l_decision_factor_tbl AS_OPPORTUNITY_PUB.Decision_Factor_Tbl_Type;
51: l_count CONSTANT NUMBER := P_decision_factor_tbl.count;
52: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;

Line 49: l_decision_factor_rec AS_OPPORTUNITY_PUB.Decision_Factor_Rec_Type;

45: l_return_status_full VARCHAR2(1);
46: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
47: l_access_flag VARCHAR2(1);
48: --P_Decision_Factor_Rec AS_OPPORTUNITY_PUB.Decision_Factor_Rec_Type;
49: l_decision_factor_rec AS_OPPORTUNITY_PUB.Decision_Factor_Rec_Type;
50: l_decision_factor_tbl AS_OPPORTUNITY_PUB.Decision_Factor_Tbl_Type;
51: l_count CONSTANT NUMBER := P_decision_factor_tbl.count;
52: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
53: l_update_access_flag VARCHAR2(1);

Line 50: l_decision_factor_tbl AS_OPPORTUNITY_PUB.Decision_Factor_Tbl_Type;

46: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
47: l_access_flag VARCHAR2(1);
48: --P_Decision_Factor_Rec AS_OPPORTUNITY_PUB.Decision_Factor_Rec_Type;
49: l_decision_factor_rec AS_OPPORTUNITY_PUB.Decision_Factor_Rec_Type;
50: l_decision_factor_tbl AS_OPPORTUNITY_PUB.Decision_Factor_Tbl_Type;
51: l_count CONSTANT NUMBER := P_decision_factor_tbl.count;
52: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
53: l_update_access_flag VARCHAR2(1);
54: l_lead_id NUMBER;

Line 155: AS_OPPORTUNITY_PUB.Get_Access_Profiles(

151: FETCH G_lead_id INTO l_lead_id;
152: CLOSE G_lead_id;
153:
154: -- Call Get_Access_Profiles to get access_profile_rec
155: AS_OPPORTUNITY_PUB.Get_Access_Profiles(
156: p_profile_tbl => p_profile_tbl,
157: x_access_profile_rec => l_access_profile_rec);
158:
159: AS_ACCESS_PUB.has_updateOpportunityAccess

Line 373: P_decision_factor_Tbl IN As_Opportunity_Pub.Decision_Factor_Tbl_Type,

369: P_Admin_Group_Id IN NUMBER,
370: P_Identity_Salesforce_Id IN NUMBER,
371: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
372: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
373: P_decision_factor_Tbl IN As_Opportunity_Pub.Decision_Factor_Tbl_Type,
374: X_decision_factor_out_tbl OUT NOCOPY as_opportunity_pub.decision_factor_out_tbl_type,
375: X_Return_Status OUT NOCOPY VARCHAR2,
376: X_Msg_Count OUT NOCOPY NUMBER,
377: X_Msg_Data OUT NOCOPY VARCHAR2

Line 374: X_decision_factor_out_tbl OUT NOCOPY as_opportunity_pub.decision_factor_out_tbl_type,

370: P_Identity_Salesforce_Id IN NUMBER,
371: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
372: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
373: P_decision_factor_Tbl IN As_Opportunity_Pub.Decision_Factor_Tbl_Type,
374: X_decision_factor_out_tbl OUT NOCOPY as_opportunity_pub.decision_factor_out_tbl_type,
375: X_Return_Status OUT NOCOPY VARCHAR2,
376: X_Msg_Count OUT NOCOPY NUMBER,
377: X_Msg_Data OUT NOCOPY VARCHAR2
378: )

Line 386: l_Decision_Factor_Rec AS_OPPORTUNITY_PUB.Decision_Factor_Rec_Type;

382: SELECT lead_id
383: FROM as_lead_lines_all
384: WHERE lead_line_id = p_lead_line_id;
385:
386: l_Decision_Factor_Rec AS_OPPORTUNITY_PUB.Decision_Factor_Rec_Type;
387: l_Decision_Factor_Tbl AS_OPPORTUNITY_PUB.Decision_Factor_Tbl_Type;
388:
389: l_api_name CONSTANT VARCHAR2(30) := 'Update_decision_factor';
390: l_api_version_number CONSTANT NUMBER := 2.0;

Line 387: l_Decision_Factor_Tbl AS_OPPORTUNITY_PUB.Decision_Factor_Tbl_Type;

383: FROM as_lead_lines_all
384: WHERE lead_line_id = p_lead_line_id;
385:
386: l_Decision_Factor_Rec AS_OPPORTUNITY_PUB.Decision_Factor_Rec_Type;
387: l_Decision_Factor_Tbl AS_OPPORTUNITY_PUB.Decision_Factor_Tbl_Type;
388:
389: l_api_name CONSTANT VARCHAR2(30) := 'Update_decision_factor';
390: l_api_version_number CONSTANT NUMBER := 2.0;
391: -- Local Variables

Line 472: AS_OPPORTUNITY_PUB.Get_Access_Profiles(

468: FETCH G_lead_id INTO l_lead_id;
469: CLOSE G_lead_id;
470:
471: -- Call Get_Access_Profiles to get access_profile_rec
472: AS_OPPORTUNITY_PUB.Get_Access_Profiles(
473: p_profile_tbl => p_profile_tbl,
474: x_access_profile_rec => l_access_profile_rec);
475:
476: AS_ACCESS_PUB.has_updateOpportunityAccess

Line 686: P_decision_factor_Tbl IN As_Opportunity_Pub.Decision_Factor_Tbl_Type,

682: P_Admin_Group_Id IN NUMBER,
683: P_identity_salesforce_id IN NUMBER := NULL,
684: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
685: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
686: P_decision_factor_Tbl IN As_Opportunity_Pub.Decision_Factor_Tbl_Type,
687: X_decision_factor_out_tbl OUT NOCOPY as_opportunity_pub.decision_factor_out_tbl_type,
688: X_Return_Status OUT NOCOPY VARCHAR2,
689: X_Msg_Count OUT NOCOPY NUMBER,
690: X_Msg_Data OUT NOCOPY VARCHAR2

Line 687: X_decision_factor_out_tbl OUT NOCOPY as_opportunity_pub.decision_factor_out_tbl_type,

683: P_identity_salesforce_id IN NUMBER := NULL,
684: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
685: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
686: P_decision_factor_Tbl IN As_Opportunity_Pub.Decision_Factor_Tbl_Type,
687: X_decision_factor_out_tbl OUT NOCOPY as_opportunity_pub.decision_factor_out_tbl_type,
688: X_Return_Status OUT NOCOPY VARCHAR2,
689: X_Msg_Count OUT NOCOPY NUMBER,
690: X_Msg_Data OUT NOCOPY VARCHAR2
691: )

Line 700: l_Decision_Factor_Rec AS_OPPORTUNITY_PUB.Decision_Factor_Rec_Type;

696: WHERE lead_line_id = p_lead_line_id;
697: l_api_name CONSTANT VARCHAR2(30) := 'Delete_decision_factor';
698: l_api_version_number CONSTANT NUMBER := 2.0;
699: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
700: l_Decision_Factor_Rec AS_OPPORTUNITY_PUB.Decision_Factor_Rec_Type;
701: l_Decision_Factor_Tbl AS_OPPORTUNITY_PUB.Decision_Factor_Tbl_Type;
702: l_rowid ROWID;
703: l_return_status_full VARCHAR2(1);
704: l_access_flag VARCHAR2(1);

Line 701: l_Decision_Factor_Tbl AS_OPPORTUNITY_PUB.Decision_Factor_Tbl_Type;

697: l_api_name CONSTANT VARCHAR2(30) := 'Delete_decision_factor';
698: l_api_version_number CONSTANT NUMBER := 2.0;
699: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
700: l_Decision_Factor_Rec AS_OPPORTUNITY_PUB.Decision_Factor_Rec_Type;
701: l_Decision_Factor_Tbl AS_OPPORTUNITY_PUB.Decision_Factor_Tbl_Type;
702: l_rowid ROWID;
703: l_return_status_full VARCHAR2(1);
704: l_access_flag VARCHAR2(1);
705: l_count CONSTANT NUMBER := P_decision_factor_tbl.count;

Line 779: AS_OPPORTUNITY_PUB.Get_Access_Profiles(

775: FETCH G_lead_id INTO l_lead_id;
776: CLOSE G_lead_id;
777:
778: -- Call Get_Access_Profiles to get access_profile_rec
779: AS_OPPORTUNITY_PUB.Get_Access_Profiles(
780: p_profile_tbl => p_profile_tbl,
781: x_access_profile_rec => l_access_profile_rec);
782:
783: AS_ACCESS_PUB.has_updateOpportunityAccess

Line 1436: P_Decision_Factor_Rec IN AS_OPPORTUNITY_PUB.Decision_Factor_Rec_Type,

1432: -- stored in database table.
1433: PROCEDURE Validate_Decision_Factor_rec(
1434: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1435: P_Validation_mode IN VARCHAR2,
1436: P_Decision_Factor_Rec IN AS_OPPORTUNITY_PUB.Decision_Factor_Rec_Type,
1437: X_Return_Status OUT NOCOPY VARCHAR2,
1438: X_Msg_Count OUT NOCOPY NUMBER,
1439: X_Msg_Data OUT NOCOPY VARCHAR2
1440: )

Line 1478: P_Decision_Factor_Rec IN AS_OPPORTUNITY_PUB.Decision_Factor_Rec_Type,

1474: PROCEDURE Validate_decision_factor(
1475: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1476: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1477: P_Validation_mode IN VARCHAR2,
1478: P_Decision_Factor_Rec IN AS_OPPORTUNITY_PUB.Decision_Factor_Rec_Type,
1479: X_Return_Status OUT NOCOPY VARCHAR2,
1480: X_Msg_Count OUT NOCOPY NUMBER,
1481: X_Msg_Data OUT NOCOPY VARCHAR2
1482: )