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_SALES_CREDIT_PVT dependencies on AS_OPPORTUNITY_PUB

Line 161: P_SALES_CREDIT_tbl IN AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type

157: P_Admin_Group_Id IN NUMBER,
158: P_Identity_Salesforce_Id IN NUMBER := NULL,
159: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
160: p_partner_cont_party_id IN NUMBER := FND_API.G_MISS_NUM,
161: P_SALES_CREDIT_tbl IN AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type
162: := AS_OPPORTUNITY_PUB.G_MISS_SALES_CREDIT_tbl,
163: X_SALES_CREDIT_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.sales_credit_out_tbl_type,
164: X_Return_Status OUT NOCOPY VARCHAR2,
165: X_Msg_Count OUT NOCOPY NUMBER,

Line 162: := AS_OPPORTUNITY_PUB.G_MISS_SALES_CREDIT_tbl,

158: P_Identity_Salesforce_Id IN NUMBER := NULL,
159: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
160: p_partner_cont_party_id IN NUMBER := FND_API.G_MISS_NUM,
161: P_SALES_CREDIT_tbl IN AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type
162: := AS_OPPORTUNITY_PUB.G_MISS_SALES_CREDIT_tbl,
163: X_SALES_CREDIT_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.sales_credit_out_tbl_type,
164: X_Return_Status OUT NOCOPY VARCHAR2,
165: X_Msg_Count OUT NOCOPY NUMBER,
166: X_Msg_Data OUT NOCOPY VARCHAR2

Line 163: X_SALES_CREDIT_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.sales_credit_out_tbl_type,

159: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
160: p_partner_cont_party_id IN NUMBER := FND_API.G_MISS_NUM,
161: P_SALES_CREDIT_tbl IN AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type
162: := AS_OPPORTUNITY_PUB.G_MISS_SALES_CREDIT_tbl,
163: X_SALES_CREDIT_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.sales_credit_out_tbl_type,
164: X_Return_Status OUT NOCOPY VARCHAR2,
165: X_Msg_Count OUT NOCOPY NUMBER,
166: X_Msg_Data OUT NOCOPY VARCHAR2
167: )

Line 234: l_sales_credit_rec AS_OPPORTUNITY_PUB.SALES_CREDIT_rec_Type;

230: l_api_name CONSTANT VARCHAR2(30) := 'Create_sales_credits';
231: l_api_version_number CONSTANT NUMBER := 2.0;
232: l_return_status_full VARCHAR2(1);
233: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
234: l_sales_credit_rec AS_OPPORTUNITY_PUB.SALES_CREDIT_rec_Type;
235: l_sales_credit_id NUMBER;
236: l_sales_credit_count CONSTANT NUMBER := P_Sales_Credit_Tbl.count;
237: l_update_access_flag VARCHAR2(1);
238: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;

Line 353: AS_OPPORTUNITY_PUB.Get_Access_Profiles(

349: END IF;
350:
351:
352: -- Call Get_Access_Profiles to get access_profile_rec
353: AS_OPPORTUNITY_PUB.Get_Access_Profiles(
354: p_profile_tbl => p_profile_tbl,
355: x_access_profile_rec => l_access_profile_rec);
356:
357: AS_ACCESS_PUB.has_updateOpportunityAccess

Line 815: P_SALES_CREDIT_tbl IN AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type,

811: P_Admin_Group_Id IN NUMBER,
812: P_Identity_Salesforce_Id IN NUMBER := NULL,
813: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
814: p_partner_cont_party_id IN NUMBER := FND_API.G_MISS_NUM,
815: P_SALES_CREDIT_tbl IN AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type,
816: X_SALES_CREDIT_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.sales_credit_out_tbl_type,
817: X_Return_Status OUT NOCOPY VARCHAR2,
818: X_Msg_Count OUT NOCOPY NUMBER,
819: X_Msg_Data OUT NOCOPY VARCHAR2

Line 816: X_SALES_CREDIT_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.sales_credit_out_tbl_type,

812: P_Identity_Salesforce_Id IN NUMBER := NULL,
813: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
814: p_partner_cont_party_id IN NUMBER := FND_API.G_MISS_NUM,
815: P_SALES_CREDIT_tbl IN AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type,
816: X_SALES_CREDIT_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.sales_credit_out_tbl_type,
817: X_Return_Status OUT NOCOPY VARCHAR2,
818: X_Msg_Count OUT NOCOPY NUMBER,
819: X_Msg_Data OUT NOCOPY VARCHAR2
820: )

Line 926: l_ref_SALES_CREDIT_rec AS_OPPORTUNITY_PUB.SALES_CREDIT_Rec_Type;

922: l_api_name CONSTANT VARCHAR2(30) := 'Update_sales_credits';
923: l_api_version_number CONSTANT NUMBER := 2.0;
924: -- Local Variables
925: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
926: l_ref_SALES_CREDIT_rec AS_OPPORTUNITY_PUB.SALES_CREDIT_Rec_Type;
927: l_tar_SALES_CREDIT_rec AS_OPPORTUNITY_PUB.SALES_CREDIT_Rec_Type;
928: l_SALES_CREDIT_rec AS_OPPORTUNITY_PUB.SALES_CREDIT_Rec_Type;
929: l_rowid ROWID;
930: l_update_access_flag VARCHAR2(1);

Line 927: l_tar_SALES_CREDIT_rec AS_OPPORTUNITY_PUB.SALES_CREDIT_Rec_Type;

923: l_api_version_number CONSTANT NUMBER := 2.0;
924: -- Local Variables
925: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
926: l_ref_SALES_CREDIT_rec AS_OPPORTUNITY_PUB.SALES_CREDIT_Rec_Type;
927: l_tar_SALES_CREDIT_rec AS_OPPORTUNITY_PUB.SALES_CREDIT_Rec_Type;
928: l_SALES_CREDIT_rec AS_OPPORTUNITY_PUB.SALES_CREDIT_Rec_Type;
929: l_rowid ROWID;
930: l_update_access_flag VARCHAR2(1);
931: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;

Line 928: l_SALES_CREDIT_rec AS_OPPORTUNITY_PUB.SALES_CREDIT_Rec_Type;

924: -- Local Variables
925: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
926: l_ref_SALES_CREDIT_rec AS_OPPORTUNITY_PUB.SALES_CREDIT_Rec_Type;
927: l_tar_SALES_CREDIT_rec AS_OPPORTUNITY_PUB.SALES_CREDIT_Rec_Type;
928: l_SALES_CREDIT_rec AS_OPPORTUNITY_PUB.SALES_CREDIT_Rec_Type;
929: l_rowid ROWID;
930: l_update_access_flag VARCHAR2(1);
931: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
932: l_freeze_flag VARCHAR2(1) := 'N'; -- solin, for bug 1554330

Line 1029: AS_OPPORTUNITY_PUB.Get_Access_Profiles(

1025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1026: END IF;
1027:
1028: -- Call Get_Access_Profiles to get access_profile_rec
1029: AS_OPPORTUNITY_PUB.Get_Access_Profiles(
1030: p_profile_tbl => p_profile_tbl,
1031: x_access_profile_rec => l_access_profile_rec);
1032:
1033: AS_ACCESS_PUB.has_updateOpportunityAccess

Line 1681: P_SALES_CREDIT_tbl IN AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type,

1677: P_Admin_Group_Id IN NUMBER,
1678: P_Identity_Salesforce_Id IN NUMBER := NULL,
1679: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
1680: p_partner_cont_party_id IN NUMBER := FND_API.G_MISS_NUM,
1681: P_SALES_CREDIT_tbl IN AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type,
1682: X_SALES_CREDIT_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.sales_credit_out_tbl_type,
1683: X_Return_Status OUT NOCOPY VARCHAR2,
1684: X_Msg_Count OUT NOCOPY NUMBER,
1685: X_Msg_Data OUT NOCOPY VARCHAR2

Line 1682: X_SALES_CREDIT_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.sales_credit_out_tbl_type,

1678: P_Identity_Salesforce_Id IN NUMBER := NULL,
1679: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
1680: p_partner_cont_party_id IN NUMBER := FND_API.G_MISS_NUM,
1681: P_SALES_CREDIT_tbl IN AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type,
1682: X_SALES_CREDIT_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.sales_credit_out_tbl_type,
1683: X_Return_Status OUT NOCOPY VARCHAR2,
1684: X_Msg_Count OUT NOCOPY NUMBER,
1685: X_Msg_Data OUT NOCOPY VARCHAR2
1686: )

Line 1707: l_SALES_CREDIT_rec AS_OPPORTUNITY_PUB.SALES_CREDIT_Rec_Type;

1703: l_api_name CONSTANT VARCHAR2(30) := 'modify_sales_credits';
1704: l_api_version_number CONSTANT NUMBER := 2.0;
1705: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
1706:
1707: l_SALES_CREDIT_rec AS_OPPORTUNITY_PUB.SALES_CREDIT_Rec_Type;
1708: l_total_forecast_amount NUMBER;
1709: l_total_forecast_percent NUMBER := 0;
1710: l_forecast_credit_type_id NUMBER := FND_PROFILE.Value('AS_FORECAST_CREDIT_TYPE_ID');
1711:

Line 1716: l_sales_credit_tbl AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type;

1712: l_update_access_flag VARCHAR2(1);
1713: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
1714:
1715: l_index NUMBER;
1716: l_sales_credit_tbl AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type;
1717: r_sales_credit_tbl AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type;
1718: n_sales_credit_tbl AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type;
1719: u_sales_credit_tbl AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type;
1720: d_sales_credit_tbl AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type;

Line 1717: r_sales_credit_tbl AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type;

1713: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
1714:
1715: l_index NUMBER;
1716: l_sales_credit_tbl AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type;
1717: r_sales_credit_tbl AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type;
1718: n_sales_credit_tbl AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type;
1719: u_sales_credit_tbl AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type;
1720: d_sales_credit_tbl AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type;
1721: l_lead_line_id NUMBER := p_sales_credit_tbl(1).lead_line_id;

Line 1718: n_sales_credit_tbl AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type;

1714:
1715: l_index NUMBER;
1716: l_sales_credit_tbl AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type;
1717: r_sales_credit_tbl AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type;
1718: n_sales_credit_tbl AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type;
1719: u_sales_credit_tbl AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type;
1720: d_sales_credit_tbl AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type;
1721: l_lead_line_id NUMBER := p_sales_credit_tbl(1).lead_line_id;
1722: l_freeze_flag VARCHAR2(1) := 'N'; -- solin, for bug 1554330

Line 1719: u_sales_credit_tbl AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type;

1715: l_index NUMBER;
1716: l_sales_credit_tbl AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type;
1717: r_sales_credit_tbl AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type;
1718: n_sales_credit_tbl AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type;
1719: u_sales_credit_tbl AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type;
1720: d_sales_credit_tbl AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type;
1721: l_lead_line_id NUMBER := p_sales_credit_tbl(1).lead_line_id;
1722: l_freeze_flag VARCHAR2(1) := 'N'; -- solin, for bug 1554330
1723: l_allow_flag VARCHAR2(1); -- solin, for bug 1554330

Line 1720: d_sales_credit_tbl AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type;

1716: l_sales_credit_tbl AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type;
1717: r_sales_credit_tbl AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type;
1718: n_sales_credit_tbl AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type;
1719: u_sales_credit_tbl AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type;
1720: d_sales_credit_tbl AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_Type;
1721: l_lead_line_id NUMBER := p_sales_credit_tbl(1).lead_line_id;
1722: l_freeze_flag VARCHAR2(1) := 'N'; -- solin, for bug 1554330
1723: l_allow_flag VARCHAR2(1); -- solin, for bug 1554330
1724: J NUMBER;

Line 1787: AS_OPPORTUNITY_PUB.Get_Access_Profiles(

1783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1784: END IF;
1785:
1786: -- Call Get_Access_Profiles to get access_profile_rec
1787: AS_OPPORTUNITY_PUB.Get_Access_Profiles(
1788: p_profile_tbl => p_profile_tbl,
1789: x_access_profile_rec => l_access_profile_rec);
1790:
1791: AS_ACCESS_PUB.has_updateOpportunityAccess

Line 2215: P_SALES_CREDIT_tbl IN AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_type,

2211: P_Admin_Group_Id IN NUMBER,
2212: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
2213: P_identity_salesforce_id IN NUMBER := NULL,
2214: p_partner_cont_party_id IN NUMBER := FND_API.G_MISS_NUM,
2215: P_SALES_CREDIT_tbl IN AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_type,
2216: X_SALES_CREDIT_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.sales_credit_out_tbl_type,
2217: X_Return_Status OUT NOCOPY VARCHAR2,
2218: X_Msg_Count OUT NOCOPY NUMBER,
2219: X_Msg_Data OUT NOCOPY VARCHAR2

Line 2216: X_SALES_CREDIT_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.sales_credit_out_tbl_type,

2212: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
2213: P_identity_salesforce_id IN NUMBER := NULL,
2214: p_partner_cont_party_id IN NUMBER := FND_API.G_MISS_NUM,
2215: P_SALES_CREDIT_tbl IN AS_OPPORTUNITY_PUB.SALES_CREDIT_tbl_type,
2216: X_SALES_CREDIT_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.sales_credit_out_tbl_type,
2217: X_Return_Status OUT NOCOPY VARCHAR2,
2218: X_Msg_Count OUT NOCOPY NUMBER,
2219: X_Msg_Data OUT NOCOPY VARCHAR2
2220: )

Line 2314: AS_OPPORTUNITY_PUB.Get_Access_Profiles(

2310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2311: END IF;
2312:
2313: -- Call Get_Access_Profiles to get access_profile_rec
2314: AS_OPPORTUNITY_PUB.Get_Access_Profiles(
2315: p_profile_tbl => p_profile_tbl,
2316: x_access_profile_rec => l_access_profile_rec);
2317:
2318: AS_ACCESS_PUB.has_updateOpportunityAccess

Line 3089: P_SALES_CREDIT_Rec IN AS_OPPORTUNITY_PUB.SALES_CREDIT_Rec_Type,

3085: -- G_MISS_XXX fields to original value stored in database table.
3086: PROCEDURE Validate_SALES_CREDIT_rec(
3087: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3088: P_Validation_mode IN VARCHAR2,
3089: P_SALES_CREDIT_Rec IN AS_OPPORTUNITY_PUB.SALES_CREDIT_Rec_Type,
3090: X_Return_Status OUT NOCOPY VARCHAR2,
3091: X_Msg_Count OUT NOCOPY NUMBER,
3092: X_Msg_Data OUT NOCOPY VARCHAR2
3093: )

Line 3290: P_SALES_CREDIT_Rec IN AS_OPPORTUNITY_PUB.SALES_CREDIT_Rec_Type,

3286: PROCEDURE Validate_sales_credit(
3287: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3288: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3289: P_Validation_mode IN VARCHAR2,
3290: P_SALES_CREDIT_Rec IN AS_OPPORTUNITY_PUB.SALES_CREDIT_Rec_Type,
3291: X_Return_Status OUT NOCOPY VARCHAR2,
3292: X_Msg_Count OUT NOCOPY NUMBER,
3293: X_Msg_Data OUT NOCOPY VARCHAR2
3294: )

Line 3525: P_SALES_CREDIT_Rec IN AS_OPPORTUNITY_PUB.SALES_CREDIT_Rec_Type,

3521: -- The following procedure added for ASNB
3522: PROCEDURE duplicate_sales_credit(
3523: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3524: P_Validation_mode IN VARCHAR2,
3525: P_SALES_CREDIT_Rec IN AS_OPPORTUNITY_PUB.SALES_CREDIT_Rec_Type,
3526: X_Return_Status OUT NOCOPY VARCHAR2,
3527: X_Msg_Count OUT NOCOPY NUMBER,
3528: X_Msg_Data OUT NOCOPY VARCHAR2
3529: ) is