eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_OPP_LINE_PVT dependencies on AS_OPPORTUNITY_PUB

Line 547: p_Line_Rec IN OUT NOCOPY AS_OPPORTUNITY_PUB.Line_Rec_Type,

543:
544: -- Local procedure to derive product category from
545: -- interest code/primary/secondary/itemid(pre 11.5.10)
546: PROCEDURE Derive_PRODUCT_CATEGORY (
547: p_Line_Rec IN OUT NOCOPY AS_OPPORTUNITY_PUB.Line_Rec_Type,
548: p_Return_Status OUT NOCOPY VARCHAR2
549: )
550: IS
551: CURSOR C_GET_CATEGORY_FROM_ITEM(l_organization_id NUMBER,

Line 706: P_Line_Tbl IN AS_OPPORTUNITY_PUB.Line_Tbl_Type :=

702: p_salesgroup_id IN NUMBER := NULL,
703: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
704: -- Suresh Mahalingam: Removed init to FND_API.G_MISS_NUM to fix GSCC warning
705: P_Partner_Cont_Party_id IN NUMBER,
706: P_Line_Tbl IN AS_OPPORTUNITY_PUB.Line_Tbl_Type :=
707: AS_OPPORTUNITY_PUB.G_MISS_Line_Tbl,
708: P_Header_Rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
709: X_LINE_OUT_TBL OUT NOCOPY AS_OPPORTUNITY_PUB.Line_out_Tbl_type,
710: X_Return_Status OUT NOCOPY VARCHAR2,

Line 707: AS_OPPORTUNITY_PUB.G_MISS_Line_Tbl,

703: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
704: -- Suresh Mahalingam: Removed init to FND_API.G_MISS_NUM to fix GSCC warning
705: P_Partner_Cont_Party_id IN NUMBER,
706: P_Line_Tbl IN AS_OPPORTUNITY_PUB.Line_Tbl_Type :=
707: AS_OPPORTUNITY_PUB.G_MISS_Line_Tbl,
708: P_Header_Rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
709: X_LINE_OUT_TBL OUT NOCOPY AS_OPPORTUNITY_PUB.Line_out_Tbl_type,
710: X_Return_Status OUT NOCOPY VARCHAR2,
711: X_Msg_Count OUT NOCOPY NUMBER,

Line 708: P_Header_Rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,

704: -- Suresh Mahalingam: Removed init to FND_API.G_MISS_NUM to fix GSCC warning
705: P_Partner_Cont_Party_id IN NUMBER,
706: P_Line_Tbl IN AS_OPPORTUNITY_PUB.Line_Tbl_Type :=
707: AS_OPPORTUNITY_PUB.G_MISS_Line_Tbl,
708: P_Header_Rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
709: X_LINE_OUT_TBL OUT NOCOPY AS_OPPORTUNITY_PUB.Line_out_Tbl_type,
710: X_Return_Status OUT NOCOPY VARCHAR2,
711: X_Msg_Count OUT NOCOPY NUMBER,
712: X_Msg_Data OUT NOCOPY VARCHAR2

Line 709: X_LINE_OUT_TBL OUT NOCOPY AS_OPPORTUNITY_PUB.Line_out_Tbl_type,

705: P_Partner_Cont_Party_id IN NUMBER,
706: P_Line_Tbl IN AS_OPPORTUNITY_PUB.Line_Tbl_Type :=
707: AS_OPPORTUNITY_PUB.G_MISS_Line_Tbl,
708: P_Header_Rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
709: X_LINE_OUT_TBL OUT NOCOPY AS_OPPORTUNITY_PUB.Line_out_Tbl_type,
710: X_Return_Status OUT NOCOPY VARCHAR2,
711: X_Msg_Count OUT NOCOPY NUMBER,
712: X_Msg_Data OUT NOCOPY VARCHAR2
713: )

Line 772: l_Line_Rec AS_OPPORTUNITY_PUB.Line_Rec_Type;

768:
769: l_api_name CONSTANT VARCHAR2(30) := 'Create_opp_lines';
770: l_api_version_number CONSTANT NUMBER := 2.0;
771: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
772: l_Line_Rec AS_OPPORTUNITY_PUB.Line_Rec_Type;
773: l_LEAD_LINE_ID NUMBER;
774: l_line_count CONSTANT NUMBER := P_Line_Tbl.count;
775: l_update_access_flag VARCHAR2(1);
776: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;

Line 778: l_sales_credit_tbl AS_OPPORTUNITY_PUB.Sales_Credit_Tbl_type;

774: l_line_count CONSTANT NUMBER := P_Line_Tbl.count;
775: l_update_access_flag VARCHAR2(1);
776: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
777:
778: l_sales_credit_tbl AS_OPPORTUNITY_PUB.Sales_Credit_Tbl_type;
779: l_sales_credit_rec AS_OPPORTUNITY_PUB.Sales_Credit_Rec_type;
780: -- l_salesgroup_id NUMBER;
781: x_sales_credit_out_tbl AS_OPPORTUNITY_PUB.Sales_Credit_Out_Tbl_Type;
782:

Line 779: l_sales_credit_rec AS_OPPORTUNITY_PUB.Sales_Credit_Rec_type;

775: l_update_access_flag VARCHAR2(1);
776: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
777:
778: l_sales_credit_tbl AS_OPPORTUNITY_PUB.Sales_Credit_Tbl_type;
779: l_sales_credit_rec AS_OPPORTUNITY_PUB.Sales_Credit_Rec_type;
780: -- l_salesgroup_id NUMBER;
781: x_sales_credit_out_tbl AS_OPPORTUNITY_PUB.Sales_Credit_Out_Tbl_Type;
782:
783: l_forecast_credit_type_id NUMBER := FND_PROFILE.Value('AS_FORECAST_CREDIT_TYPE_ID');

Line 781: x_sales_credit_out_tbl AS_OPPORTUNITY_PUB.Sales_Credit_Out_Tbl_Type;

777:
778: l_sales_credit_tbl AS_OPPORTUNITY_PUB.Sales_Credit_Tbl_type;
779: l_sales_credit_rec AS_OPPORTUNITY_PUB.Sales_Credit_Rec_type;
780: -- l_salesgroup_id NUMBER;
781: x_sales_credit_out_tbl AS_OPPORTUNITY_PUB.Sales_Credit_Out_Tbl_Type;
782:
783: l_forecast_credit_type_id NUMBER := FND_PROFILE.Value('AS_FORECAST_CREDIT_TYPE_ID');
784: l_isd_credit_type_id NUMBER := FND_PROFILE.Value('AS_ISD_CREDIT_TYPE_ID');
785: l_isd_sales_group_id NUMBER := FND_PROFILE.Value('AS_ISD_SALES_GROUP_ID');

Line 908: AS_OPPORTUNITY_PUB.Get_Access_Profiles(

904:
905: IF(P_Check_Access_Flag = 'Y') THEN
906:
907: -- Call Get_Access_Profiles to get access_profile_rec
908: AS_OPPORTUNITY_PUB.Get_Access_Profiles(
909: p_profile_tbl => p_profile_tbl,
910: x_access_profile_rec => l_access_profile_rec);
911:
912: AS_ACCESS_PUB.has_updateOpportunityAccess

Line 1466: P_Line_Tbl IN AS_OPPORTUNITY_PUB.Line_Tbl_Type,

1462: P_Identity_Salesforce_Id IN NUMBER := NULL,
1463: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
1464: -- Suresh Mahalingam: Removed init to FND_API.G_MISS_NUM to fix GSCC warning
1465: P_Partner_Cont_Party_id IN NUMBER,
1466: P_Line_Tbl IN AS_OPPORTUNITY_PUB.Line_Tbl_Type,
1467: P_Header_Rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
1468: X_LINE_OUT_TBL OUT NOCOPY AS_OPPORTUNITY_PUB.Line_out_Tbl_type,
1469: X_Return_Status OUT NOCOPY VARCHAR2,
1470: X_Msg_Count OUT NOCOPY NUMBER,

Line 1467: P_Header_Rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,

1463: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
1464: -- Suresh Mahalingam: Removed init to FND_API.G_MISS_NUM to fix GSCC warning
1465: P_Partner_Cont_Party_id IN NUMBER,
1466: P_Line_Tbl IN AS_OPPORTUNITY_PUB.Line_Tbl_Type,
1467: P_Header_Rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
1468: X_LINE_OUT_TBL OUT NOCOPY AS_OPPORTUNITY_PUB.Line_out_Tbl_type,
1469: X_Return_Status OUT NOCOPY VARCHAR2,
1470: X_Msg_Count OUT NOCOPY NUMBER,
1471: X_Msg_Data OUT NOCOPY VARCHAR2

Line 1468: X_LINE_OUT_TBL OUT NOCOPY AS_OPPORTUNITY_PUB.Line_out_Tbl_type,

1464: -- Suresh Mahalingam: Removed init to FND_API.G_MISS_NUM to fix GSCC warning
1465: P_Partner_Cont_Party_id IN NUMBER,
1466: P_Line_Tbl IN AS_OPPORTUNITY_PUB.Line_Tbl_Type,
1467: P_Header_Rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
1468: X_LINE_OUT_TBL OUT NOCOPY AS_OPPORTUNITY_PUB.Line_out_Tbl_type,
1469: X_Return_Status OUT NOCOPY VARCHAR2,
1470: X_Msg_Count OUT NOCOPY NUMBER,
1471: X_Msg_Data OUT NOCOPY VARCHAR2
1472: )

Line 1496: l_ref_Line_rec AS_OPPORTUNITY_PUB.Line_Rec_Type;

1492: l_api_name CONSTANT VARCHAR2(30) := 'Update_opp_lines';
1493: l_api_version_number CONSTANT NUMBER := 2.0;
1494: -- Local Variables
1495: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
1496: l_ref_Line_rec AS_OPPORTUNITY_PUB.Line_Rec_Type;
1497: l_rowid ROWID;
1498: l_Line_Rec AS_OPPORTUNITY_PUB.Line_Rec_Type;
1499: l_line_count CONSTANT NUMBER := P_Line_Tbl.count;
1500: l_last_update_date DATE;

Line 1498: l_Line_Rec AS_OPPORTUNITY_PUB.Line_Rec_Type;

1494: -- Local Variables
1495: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
1496: l_ref_Line_rec AS_OPPORTUNITY_PUB.Line_Rec_Type;
1497: l_rowid ROWID;
1498: l_Line_Rec AS_OPPORTUNITY_PUB.Line_Rec_Type;
1499: l_line_count CONSTANT NUMBER := P_Line_Tbl.count;
1500: l_last_update_date DATE;
1501: l_update_access_flag VARCHAR2(1);
1502: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;

Line 1587: AS_OPPORTUNITY_PUB.Get_Access_Profiles(

1583: END IF;
1584:
1585:
1586: -- Call Get_Access_Profiles to get access_profile_rec
1587: AS_OPPORTUNITY_PUB.Get_Access_Profiles(
1588: p_profile_tbl => p_profile_tbl,
1589: x_access_profile_rec => l_access_profile_rec);
1590:
1591: AS_ACCESS_PUB.has_updateOpportunityAccess

Line 1986: P_Line_Tbl IN AS_OPPORTUNITY_PUB.Line_Tbl_Type,

1982: P_identity_salesforce_id IN NUMBER := NULL,
1983: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
1984: -- Suresh Mahalingam: Removed init to FND_API.G_MISS_NUM to fix GSCC warning
1985: P_Partner_Cont_Party_id IN NUMBER,
1986: P_Line_Tbl IN AS_OPPORTUNITY_PUB.Line_Tbl_Type,
1987: P_Header_Rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
1988: X_LINE_OUT_TBL OUT NOCOPY AS_OPPORTUNITY_PUB.Line_out_Tbl_type,
1989: X_Return_Status OUT NOCOPY VARCHAR2,
1990: X_Msg_Count OUT NOCOPY NUMBER,

Line 1987: P_Header_Rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,

1983: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
1984: -- Suresh Mahalingam: Removed init to FND_API.G_MISS_NUM to fix GSCC warning
1985: P_Partner_Cont_Party_id IN NUMBER,
1986: P_Line_Tbl IN AS_OPPORTUNITY_PUB.Line_Tbl_Type,
1987: P_Header_Rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
1988: X_LINE_OUT_TBL OUT NOCOPY AS_OPPORTUNITY_PUB.Line_out_Tbl_type,
1989: X_Return_Status OUT NOCOPY VARCHAR2,
1990: X_Msg_Count OUT NOCOPY NUMBER,
1991: X_Msg_Data OUT NOCOPY VARCHAR2

Line 1988: X_LINE_OUT_TBL OUT NOCOPY AS_OPPORTUNITY_PUB.Line_out_Tbl_type,

1984: -- Suresh Mahalingam: Removed init to FND_API.G_MISS_NUM to fix GSCC warning
1985: P_Partner_Cont_Party_id IN NUMBER,
1986: P_Line_Tbl IN AS_OPPORTUNITY_PUB.Line_Tbl_Type,
1987: P_Header_Rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
1988: X_LINE_OUT_TBL OUT NOCOPY AS_OPPORTUNITY_PUB.Line_out_Tbl_type,
1989: X_Return_Status OUT NOCOPY VARCHAR2,
1990: X_Msg_Count OUT NOCOPY NUMBER,
1991: X_Msg_Data OUT NOCOPY VARCHAR2
1992: )

Line 2021: l_Line_Rec AS_OPPORTUNITY_PUB.Line_Rec_Type;

2017:
2018: l_api_name CONSTANT VARCHAR2(30) := 'Delete_opp_lines';
2019: l_api_version_number CONSTANT NUMBER := 2.0;
2020: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
2021: l_Line_Rec AS_OPPORTUNITY_PUB.Line_Rec_Type;
2022: l_LEAD_LINE_ID NUMBER;
2023: l_line_count CONSTANT NUMBER := P_Line_Tbl.count;
2024: l_update_access_flag VARCHAR2(1);
2025: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;

Line 2108: AS_OPPORTUNITY_PUB.Get_Access_Profiles(

2104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2105: END IF;
2106:
2107: -- Call Get_Access_Profiles to get access_profile_rec
2108: AS_OPPORTUNITY_PUB.Get_Access_Profiles(
2109: p_profile_tbl => p_profile_tbl,
2110: x_access_profile_rec => l_access_profile_rec);
2111:
2112: AS_ACCESS_PUB.has_updateOpportunityAccess

Line 3531: P_Line_Rec IN AS_OPPORTUNITY_PUB.Line_Rec_Type,

3527: -- table.
3528: PROCEDURE Validate_Line_rec(
3529: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3530: P_Validation_mode IN VARCHAR2,
3531: P_Line_Rec IN AS_OPPORTUNITY_PUB.Line_Rec_Type,
3532: X_Return_Status OUT NOCOPY VARCHAR2,
3533: X_Msg_Count OUT NOCOPY NUMBER,
3534: X_Msg_Data OUT NOCOPY VARCHAR2
3535: )

Line 3686: P_Line_Rec IN AS_OPPORTUNITY_PUB.Line_Rec_Type,

3682: PROCEDURE Validate_opp_line(
3683: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3684: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3685: P_Validation_mode IN VARCHAR2,
3686: P_Line_Rec IN AS_OPPORTUNITY_PUB.Line_Rec_Type,
3687: X_Return_Status OUT NOCOPY VARCHAR2,
3688: X_Msg_Count OUT NOCOPY NUMBER,
3689: X_Msg_Data OUT NOCOPY VARCHAR2
3690: )