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_SALES_LEAD_LINES_PVT dependencies on AS_SALES_LEADS

Line 44: UPDATE as_sales_leads

40: OPEN C_line_total;
41: FETCH C_line_total into l_line_total;
42: CLOSE C_line_total;
43:
44: UPDATE as_sales_leads
45: SET total_amount = nvl(l_line_total, 0),
46: last_update_date = SYSDATE,
47: last_updated_by = FND_GLOBAL.USER_ID,
48: -- creation_Date = SYSDATE, -- solin, for bug 1579950

Line 83: FROM as_sales_leads

79: )
80: IS
81: CURSOR C_Sales_Lead_Id_Exists (X_Sales_Lead_Id NUMBER) IS
82: SELECT 'X'
83: FROM as_sales_leads
84: WHERE sales_lead_id = X_Sales_Lead_Id;
85:
86: l_val VARCHAR2(1);
87:

Line 700: FROM as_sales_leads

696: )
697: IS
698: CURSOR C_Header_Amount (X_Sales_Lead_ID NUMBER) IS
699: SELECT budget_amount
700: FROM as_sales_leads
701: where sales_lead_id = X_Sales_Lead_ID;
702:
703: CURSOR C_Lines_Amounts (X_Sales_Lead_ID NUMBER) IS
704: SELECT sum (budget_amount)

Line 756: P_SALES_LEAD_LINE_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Rec_Type,

752: PROCEDURE Validate_sales_lead_line(
753: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
754: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
755: P_Validation_mode IN VARCHAR2,
756: P_SALES_LEAD_LINE_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Rec_Type,
757: X_Return_Status OUT NOCOPY VARCHAR2,
758: X_Msg_Count OUT NOCOPY NUMBER,
759: X_Msg_Data OUT NOCOPY VARCHAR2
760: )

Line 808: AS_SALES_LEADS_PVT.Validate_SOURCE_PROMOTION_ID(

804: */
805: -- end of ffang 092800
806:
807: -- ffang 080201, add validate source_promotion_id and offer_id
808: AS_SALES_LEADS_PVT.Validate_SOURCE_PROMOTION_ID(
809: p_init_msg_list => FND_API.G_FALSE,
810: p_validation_mode => p_validation_mode,
811: p_SOURCE_PROMOTION_ID =>P_SALES_LEAD_LINE_Rec.SOURCE_PROMOTION_ID,
812: x_return_status => x_return_status,

Line 820: AS_SALES_LEADS_PVT.Validate_OFFER_ID(

816: l_return_status := FND_API.G_RET_STS_ERROR;
817: -- raise FND_API.G_EXC_ERROR;
818: END IF;
819:
820: AS_SALES_LEADS_PVT.Validate_OFFER_ID(
821: p_init_msg_list => FND_API.G_FALSE,
822: p_validation_mode => p_validation_mode,
823: P_SOURCE_PROMOTION_ID =>P_SALES_LEAD_LINE_Rec.source_promotion_id,
824: p_OFFER_ID => P_SALES_LEAD_LINE_Rec.OFFER_ID,

Line 991: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type

987: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
988: P_Identity_Salesforce_Id IN NUMBER := FND_API.G_MISS_NUM,
989: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
990: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
991: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type
992: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_LINE_Tbl,
993: P_SALES_LEAD_ID IN NUMBER,
994: X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_Type,
995: X_Return_Status OUT NOCOPY VARCHAR2,

Line 992: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_LINE_Tbl,

988: P_Identity_Salesforce_Id IN NUMBER := FND_API.G_MISS_NUM,
989: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
990: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
991: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type
992: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_LINE_Tbl,
993: P_SALES_LEAD_ID IN NUMBER,
994: X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_Type,
995: X_Return_Status OUT NOCOPY VARCHAR2,
996: X_Msg_Count OUT NOCOPY NUMBER,

Line 994: X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_Type,

990: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
991: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type
992: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_LINE_Tbl,
993: P_SALES_LEAD_ID IN NUMBER,
994: X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_Type,
995: X_Return_Status OUT NOCOPY VARCHAR2,
996: X_Msg_Count OUT NOCOPY NUMBER,
997: X_Msg_Data OUT NOCOPY VARCHAR2
998: )

Line 1005: l_SALES_LEAD_LINE_rec AS_SALES_LEADS_PUB.SALES_LEAD_LINE_rec_type;

1001: l_api_name CONSTANT VARCHAR2(30) := 'Create_sales_lead_lines';
1002: l_api_version_number CONSTANT NUMBER := 2.0;
1003: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
1004: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
1005: l_SALES_LEAD_LINE_rec AS_SALES_LEADS_PUB.SALES_LEAD_LINE_rec_type;
1006: l_sales_lead_line_id NUMBER;
1007: l_customer_id NUMBER;
1008: l_address_id NUMBER;
1009: l_update_access_flag VARCHAR2(1);

Line 1021: FROM as_sales_leads

1017: -- ffang 090801, for bug 1978014
1018: -- Default source_promotion_id as header's
1019: CURSOR C_Get_Header_Campaign (c_sales_lead_id NUMBER) IS
1020: SELECT source_promotion_id, offer_id
1021: FROM as_sales_leads
1022: WHERE sales_lead_id = c_sales_lead_id;
1023:
1024: CURSOR C_Get_Category_set_ID (X_cat_Id NUMBER) IS
1025: SELECT category_set_id

Line 1304: AS_SALES_LEADS_PUB.Get_Access_Profiles(

1300: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1301: 'Calling Get_Access_Profiles');
1302: END IF;
1303:
1304: AS_SALES_LEADS_PUB.Get_Access_Profiles(
1305: p_profile_tbl => p_sales_lead_profile_tbl,
1306: x_access_profile_rec => l_access_profile_rec);
1307:
1308: IF (AS_DEBUG_LOW_ON) THEN

Line 1440: UPDATE as_sales_leads

1436: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1437: 'Updating Header Budget Amount');
1438: END IF;
1439:
1440: UPDATE as_sales_leads
1441: SET budget_amount = nvl(budget_amount, 0) + l_lines_amount
1442: WHERE sales_lead_id = p_SALES_LEAD_ID;
1443:
1444: -- Debug Message

Line 1547: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type,

1543: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
1544: P_Identity_Salesforce_Id IN NUMBER := FND_API.G_MISS_NUM,
1545: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1546: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1547: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type,
1548: X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_Type,
1549: X_Return_Status OUT NOCOPY VARCHAR2,
1550: X_Msg_Count OUT NOCOPY NUMBER,
1551: X_Msg_Data OUT NOCOPY VARCHAR2

Line 1548: X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_Type,

1544: P_Identity_Salesforce_Id IN NUMBER := FND_API.G_MISS_NUM,
1545: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1546: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1547: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type,
1548: X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_Type,
1549: X_Return_Status OUT NOCOPY VARCHAR2,
1550: X_Msg_Count OUT NOCOPY NUMBER,
1551: X_Msg_Data OUT NOCOPY VARCHAR2
1552: )

Line 1565: l_tar_SALES_LEAD_LINE_rec AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Rec_Type;

1561: l_api_name CONSTANT VARCHAR2(30) := 'Update_sales_lead_lines';
1562: l_api_version_number CONSTANT NUMBER := 2.0;
1563: -- Local Variables
1564: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
1565: l_tar_SALES_LEAD_LINE_rec AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Rec_Type;
1566: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
1567: l_Sales_Lead_Id NUMBER;
1568: l_Sales_Lead_Line_Id NUMBER;
1569: l_last_update_date DATE;

Line 1751: AS_SALES_LEADS_PUB.Get_Access_Profiles(

1747: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1748: 'Calling Get_Access_Profiles');
1749: END IF;
1750:
1751: AS_SALES_LEADS_PUB.Get_Access_Profiles(
1752: p_profile_tbl => p_sales_lead_profile_tbl,
1753: x_access_profile_rec => l_access_profile_rec);
1754:
1755: IF (AS_DEBUG_LOW_ON) THEN

Line 1876: UPDATE as_sales_leads

1872: */
1873: END LOOP;
1874:
1875: /*
1876: UPDATE as_sales_leads
1877: SET budget_amount = budget_amount + l_update_amounts
1878: WHERE sales_lead_id = l_sales_lead_id;
1879:
1880: -- Debug Message

Line 1978: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type,

1974: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
1975: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
1976: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1977: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1978: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type,
1979: X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_Type,
1980: X_Return_Status OUT NOCOPY VARCHAR2,
1981: X_Msg_Count OUT NOCOPY NUMBER,
1982: X_Msg_Data OUT NOCOPY VARCHAR2

Line 1979: X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_Type,

1975: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
1976: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1977: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1978: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type,
1979: X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_Type,
1980: X_Return_Status OUT NOCOPY VARCHAR2,
1981: X_Msg_Count OUT NOCOPY NUMBER,
1982: X_Msg_Data OUT NOCOPY VARCHAR2
1983: )

Line 1995: l_sales_lead_line_rec AS_SALES_LEADS_PUB.Sales_Lead_Line_Rec_Type;

1991: l_api_name CONSTANT VARCHAR2(30) := 'Delete_sales_lead_lines';
1992: l_api_version_number CONSTANT NUMBER := 2.0;
1993: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
1994: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
1995: l_sales_lead_line_rec AS_SALES_LEADS_PUB.Sales_Lead_Line_Rec_Type;
1996: l_last_update_date DATE;
1997: l_delete_amounts NUMBER;
1998: l_budget_amount NUMBER;
1999: l_update_access_flag VARCHAR2(1);

Line 2116: AS_SALES_LEADS_PUB.Get_Access_Profiles(

2112: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2113: 'Calling Get_Access_Profiles');
2114: END IF;
2115:
2116: AS_SALES_LEADS_PUB.Get_Access_Profiles(
2117: p_profile_tbl => p_sales_lead_profile_tbl,
2118: x_access_profile_rec => l_access_profile_rec);
2119:
2120: IF (AS_DEBUG_LOW_ON) THEN

Line 2184: UPDATE as_sales_leads

2180: END IF;
2181: END LOOP;
2182:
2183: /*
2184: UPDATE as_sales_leads
2185: SET budget_amount = budget_amount - l_delete_amounts
2186: WHERE sales_lead_id = l_sales_lead_line_rec.sales_lead_id;
2187:
2188: -- Debug Message