APPS.AS_SALES_LEAD_LINES_PVT dependencies on AS_SALES_LEAD_LINES

Line 1: PACKAGE BODY AS_SALES_LEAD_LINES_PVT as

1: PACKAGE BODY AS_SALES_LEAD_LINES_PVT as
2: /* $Header: asxvsllb.pls 120.2 2006/08/25 21:29:35 solin noship $ */
3: -- Start of Comments
4: -- Package name : AS_SALES_LEAD_LINES_PVT
5: -- Purpose : Sales Leads Lines

Line 4: -- Package name : AS_SALES_LEAD_LINES_PVT

1: PACKAGE BODY AS_SALES_LEAD_LINES_PVT as
2: /* $Header: asxvsllb.pls 120.2 2006/08/25 21:29:35 solin noship $ */
3: -- Start of Comments
4: -- Package name : AS_SALES_LEAD_LINES_PVT
5: -- Purpose : Sales Leads Lines
6: -- NOTE :
7: -- History :
8: -- 03/29/2001 FFANG Created.

Line 13: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AS_SALES_LEAD_LINES_PVT';

9: --
10: -- END of Comments
11:
12:
13: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AS_SALES_LEAD_LINES_PVT';
14: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asxvsllb.pls';
15:
16: -- Local procedure to reset Opp Header with total_amount
17: -- by the sum of the total_amounts of the lines

Line 32: FROM as_sales_lead_lines

28: IS
29:
30: CURSOR C_line_total IS
31: SELECT sum(budget_amount) line_total
32: FROM as_sales_lead_lines
33: WHERE sales_lead_id = p_sales_lead_id;
34:
35: l_line_total NUMBER;
36:

Line 705: FROM as_sales_lead_lines

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)
705: FROM as_sales_lead_lines
706: where sales_lead_id = X_Sales_Lead_ID;
707:
708: l_header_amount NUMBER;
709: l_lines_amounts NUMBER;

Line 787: -- ffang 092800: status_code in as_sales_lead_lines has been obselete

783: IF ( P_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_ITEM)
784: THEN
785: -- Perform item level validation
786:
787: -- ffang 092800: status_code in as_sales_lead_lines has been obselete
788: /*
789: IF (P_SALES_LEAD_LINE_Rec.STATUS_CODE IS NOT NULL
790: and P_SALES_LEAD_LINE_Rec.STATUS_CODE <> FND_API.G_MISS_CHAR)
791: THEN

Line 1360: AS_SALES_LEAD_LINES_PKG.Sales_Lead_Line_Insert_Row(

1356:
1357: l_sales_lead_line_id := l_sales_lead_line_rec.sales_lead_line_id;
1358:
1359: -- Invoke table handler(Sales_Lead_Line_Insert_Row)
1360: AS_SALES_LEAD_LINES_PKG.Sales_Lead_Line_Insert_Row(
1361: px_SALES_LEAD_LINE_ID => l_sales_lead_line_id,
1362: p_LAST_UPDATE_DATE => SYSDATE,
1363: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1364: p_CREATION_DATE => SYSDATE,

Line 1557: From AS_SALES_LEAD_LINES

1553: IS
1554: Cursor C_Get_sales_lead_line(c_SALES_LEAD_LINE_ID Number) IS
1555: Select LAST_UPDATE_DATE,
1556: BUDGET_AMOUNT
1557: From AS_SALES_LEAD_LINES
1558: WHERE sales_lead_line_id = c_sales_lead_line_id
1559: For Update NOWAIT;
1560:
1561: l_api_name CONSTANT VARCHAR2(30) := 'Update_sales_lead_lines';

Line 1804: AS_SALES_LEAD_LINES_PKG.Sales_Lead_line_Update_Row(

1800: 'Calling line_Update_Row');
1801: END IF;
1802:
1803: -- Invoke table handler(sales_lead_line_Update_Row)
1804: AS_SALES_LEAD_LINES_PKG.Sales_Lead_line_Update_Row(
1805: p_SALES_LEAD_LINE_ID => l_tar_SALES_LEAD_LINE_rec.SALES_LEAD_LINE_ID,
1806: p_LAST_UPDATE_DATE => SYSDATE,
1807: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1808: p_CREATION_DATE => l_tar_SALES_LEAD_LINE_rec.CREATION_DATE,

Line 1987: From AS_SALES_LEAD_LINES

1983: )
1984: IS
1985: Cursor C_Get_sales_lead_line(c_SALES_LEAD_LINE_ID Number) IS
1986: Select LAST_UPDATE_DATE, BUDGET_AMOUNT
1987: From AS_SALES_LEAD_LINES
1988: WHERE sales_lead_line_id = c_sales_lead_line_id
1989: For Update NOWAIT;
1990:
1991: l_api_name CONSTANT VARCHAR2(30) := 'Delete_sales_lead_lines';

Line 2169: AS_SALES_LEAD_LINES_PKG.Sales_Lead_Line_Delete_Row(

2165: 'Calling_Line_Delete_Row');
2166: END IF;
2167:
2168: -- Invoke table handler(Sales_Lead_Line_Delete_Row)
2169: AS_SALES_LEAD_LINES_PKG.Sales_Lead_Line_Delete_Row(
2170: p_SALES_LEAD_LINE_ID => l_SALES_LEAD_LINE_rec.SALES_LEAD_LINE_ID);
2171:
2172: x_sales_lead_line_out_tbl(l_curr_row).sales_lead_line_id
2173: := l_sales_lead_line_rec.sales_lead_line_id;

Line 2265: END AS_SALES_LEAD_LINES_PVT;

2261: ,X_RETURN_STATUS => X_RETURN_STATUS);
2262: END Delete_sales_lead_lines;
2263:
2264:
2265: END AS_SALES_LEAD_LINES_PVT;