DBA Data[Home] [Help]

APPS.AS_OPP_HEADER_PVT dependencies on AS_OPPORTUNITY_PUB

Line 83: p_opp_rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,

79:
80: -- ffang 091400, Add p_mode and checking g_miss_xxx
81: PROCEDURE Set_opp_default_values (
82: p_mode IN VARCHAR2,
83: p_opp_rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
84: x_opp_rec OUT NOCOPY AS_OPPORTUNITY_PUB.Header_Rec_Type
85: )
86:
87: IS

Line 84: x_opp_rec OUT NOCOPY AS_OPPORTUNITY_PUB.Header_Rec_Type

80: -- ffang 091400, Add p_mode and checking g_miss_xxx
81: PROCEDURE Set_opp_default_values (
82: p_mode IN VARCHAR2,
83: p_opp_rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
84: x_opp_rec OUT NOCOPY AS_OPPORTUNITY_PUB.Header_Rec_Type
85: )
86:
87: IS
88: l_opp_rec AS_OPPORTUNITY_PUB.Header_Rec_Type := p_opp_rec;

Line 88: l_opp_rec AS_OPPORTUNITY_PUB.Header_Rec_Type := p_opp_rec;

84: x_opp_rec OUT NOCOPY AS_OPPORTUNITY_PUB.Header_Rec_Type
85: )
86:
87: IS
88: l_opp_rec AS_OPPORTUNITY_PUB.Header_Rec_Type := p_opp_rec;
89:
90: BEGIN
91: IF nvl(fnd_profile.value('AS_ACTIVATE_SALES_INTEROP'), 'N') <> 'Y' THEN -- Added for ASNB
92: If (l_opp_rec.sales_stage_id IS NULL) or

Line 179: p_header_rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,

175:
176:
177: PROCEDURE HEADER_CREATE_NOTE(
178: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
179: p_header_rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
180: p_lead_number IN VARCHAR2,
181: p_win_prob IN NUMBER,
182: p_status IN VARCHAR2,
183: p_sales_stage_id IN NUMBER,

Line 558: l_competitor_rec AS_OPPORTUNITY_PUB.Competitor_rec_Type;

554: and competitor_id = p_competitor_id;
555:
556: l_competitor_exist VARCHAR2(1);
557:
558: l_competitor_rec AS_OPPORTUNITY_PUB.Competitor_rec_Type;
559: l_competitor_tbl AS_OPPORTUNITY_PUB.Competitor_tbl_Type;
560: x_competitor_out_tbl AS_OPPORTUNITY_PUB.Competitor_Out_Tbl_Type;
561:
562: BEGIN

Line 559: l_competitor_tbl AS_OPPORTUNITY_PUB.Competitor_tbl_Type;

555:
556: l_competitor_exist VARCHAR2(1);
557:
558: l_competitor_rec AS_OPPORTUNITY_PUB.Competitor_rec_Type;
559: l_competitor_tbl AS_OPPORTUNITY_PUB.Competitor_tbl_Type;
560: x_competitor_out_tbl AS_OPPORTUNITY_PUB.Competitor_Out_Tbl_Type;
561:
562: BEGIN
563:

Line 560: x_competitor_out_tbl AS_OPPORTUNITY_PUB.Competitor_Out_Tbl_Type;

556: l_competitor_exist VARCHAR2(1);
557:
558: l_competitor_rec AS_OPPORTUNITY_PUB.Competitor_rec_Type;
559: l_competitor_tbl AS_OPPORTUNITY_PUB.Competitor_tbl_Type;
560: x_competitor_out_tbl AS_OPPORTUNITY_PUB.Competitor_Out_Tbl_Type;
561:
562: BEGIN
563:
564: -- Initialize API return status to SUCCESS

Line 642: P_Header_Rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type

638: P_Identity_Salesforce_Id IN NUMBER := NULL,
639: P_salesgroup_id IN NUMBER := NULL,
640: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
641: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
642: P_Header_Rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type
643: := AS_OPPORTUNITY_PUB.G_MISS_Header_REC,
644: X_LEAD_ID OUT NOCOPY NUMBER,
645: X_Return_Status OUT NOCOPY VARCHAR2,
646: X_Msg_Count OUT NOCOPY NUMBER,

Line 643: := AS_OPPORTUNITY_PUB.G_MISS_Header_REC,

639: P_salesgroup_id IN NUMBER := NULL,
640: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
641: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
642: P_Header_Rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type
643: := AS_OPPORTUNITY_PUB.G_MISS_Header_REC,
644: X_LEAD_ID OUT NOCOPY NUMBER,
645: X_Return_Status OUT NOCOPY VARCHAR2,
646: X_Msg_Count OUT NOCOPY NUMBER,
647: X_Msg_Data OUT NOCOPY VARCHAR2

Line 656: l_header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type

652: l_api_version_number CONSTANT NUMBER := 2.0;
653: l_return_status_full VARCHAR2(1);
654: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
655: l_LEAD_ID NUMBER;
656: l_header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type
657: := P_Header_Rec;
658: l_header_rec1 AS_OPPORTUNITY_PUB.Header_Rec_Type;
659:
660: l_access_profile_rec AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;

Line 658: l_header_rec1 AS_OPPORTUNITY_PUB.Header_Rec_Type;

654: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
655: l_LEAD_ID NUMBER;
656: l_header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type
657: := P_Header_Rec;
658: l_header_rec1 AS_OPPORTUNITY_PUB.Header_Rec_Type;
659:
660: l_access_profile_rec AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;
661: l_access_flag VARCHAR2(1);
662: l_access_id NUMBER;

Line 902: AS_OPPORTUNITY_PUB.Get_Access_Profiles(

898: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
899: 'Calling Get_Access_Profiles');
900: END IF;
901:
902: AS_OPPORTUNITY_PUB.Get_Access_Profiles(
903: p_profile_tbl => p_profile_tbl,
904: x_access_profile_rec => l_access_profile_rec);
905:
906: IF l_debug THEN

Line 1421: P_Header_Rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,

1417: P_Admin_Group_Id IN NUMBER,
1418: P_Identity_Salesforce_Id IN NUMBER := NULL,
1419: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
1420: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
1421: P_Header_Rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
1422: X_Return_Status OUT NOCOPY VARCHAR2,
1423: X_Msg_Count OUT NOCOPY NUMBER,
1424: X_Msg_Data OUT NOCOPY VARCHAR2
1425: )

Line 1480: --l_tar_Header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type := P_Header_Rec;

1476: l_api_name CONSTANT VARCHAR2(30) := 'Update_opp_header';
1477: l_api_version_number CONSTANT NUMBER := 2.0;
1478: -- Local Variables
1479: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
1480: --l_tar_Header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type := P_Header_Rec;
1481: l_access_profile_rec AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;
1482: l_access_flag VARCHAR2(1);
1483: l_deleted_flag VARCHAR2(1);
1484: l_access_id NUMBER;

Line 1493: l_header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type := P_Header_Rec;

1489: l_decision_date DATE;
1490: l_lead_number VARCHAR2(30);
1491: l_freeze_flag VARCHAR2(1); -- solin, bug 1554330
1492: l_note_id NUMBER;
1493: l_header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type := P_Header_Rec;
1494: l_header_rec1 AS_OPPORTUNITY_PUB.Header_Rec_Type;
1495: l_allow_flag VARCHAR2(1); -- solin, bug 1554330
1496:
1497: l_old_sales_methodology_id NUMBER := null;

Line 1494: l_header_rec1 AS_OPPORTUNITY_PUB.Header_Rec_Type;

1490: l_lead_number VARCHAR2(30);
1491: l_freeze_flag VARCHAR2(1); -- solin, bug 1554330
1492: l_note_id NUMBER;
1493: l_header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type := P_Header_Rec;
1494: l_header_rec1 AS_OPPORTUNITY_PUB.Header_Rec_Type;
1495: l_allow_flag VARCHAR2(1); -- solin, bug 1554330
1496:
1497: l_old_sales_methodology_id NUMBER := null;
1498: l_old_sales_stage_id NUMBER := null;

Line 1794: AS_OPPORTUNITY_PUB.Get_Access_Profiles(

1790: END IF;
1791:
1792: */
1793: -- Call Get_Access_Profiles to get access_profile_rec
1794: AS_OPPORTUNITY_PUB.Get_Access_Profiles(
1795: p_profile_tbl => p_profile_tbl,
1796: x_access_profile_rec => l_access_profile_rec);
1797:
1798:

Line 2681: AS_OPPORTUNITY_PUB.Get_Access_Profiles(

2677: */
2678:
2679:
2680: -- Call Get_Access_Profiles to get access_profile_rec
2681: AS_OPPORTUNITY_PUB.Get_Access_Profiles(
2682: p_profile_tbl => p_profile_tbl,
2683: x_access_profile_rec => l_access_profile_rec);
2684:
2685:

Line 5871: P_Header_Rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,

5867: PROCEDURE Validate_opp_header(
5868: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
5869: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
5870: P_Validation_mode IN VARCHAR2,
5871: P_Header_Rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
5872: X_Return_Status OUT NOCOPY VARCHAR2,
5873: X_Msg_Count OUT NOCOPY NUMBER,
5874: X_Msg_Data OUT NOCOPY VARCHAR2
5875: