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_OPP_PVT dependencies on FND_GLOBAL

Line 298: IF FND_GLOBAL.User_Id IS NULL

294: --
295: -- ******************************************************************
296: -- Validate Environment
297: -- ******************************************************************
298: IF FND_GLOBAL.User_Id IS NULL
299: THEN
300: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
301: THEN
302: AS_UTILITY_PVT.Set_Message(

Line 867: IF FND_GLOBAL.User_Id IS NULL

863:
864: -- ******************************************************************
865: -- Validate Environment
866: -- ******************************************************************
867: IF FND_GLOBAL.User_Id IS NULL
868: THEN
869: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
870: THEN
871: AS_UTILITY_PVT.Set_Message(

Line 1313: ,p_LAST_UPDATED_BY => FND_GLOBAL.User_Id

1309: ,p_SALES_LEAD_LINE_ID =>
1310: l_sales_lead_line_tbl(l_index).sales_lead_line_id
1311: ,p_OPP_LINE_ID => l_line_out_tbl(l_index).lead_line_id
1312: ,p_LAST_UPDATE_DATE => SYSDATE
1313: ,p_LAST_UPDATED_BY => FND_GLOBAL.User_Id
1314: ,p_CREATION_DATE => SYSDATE
1315: ,p_CREATED_BY => FND_GLOBAL.User_Id
1316: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.Conc_Login_Id
1317: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id

Line 1315: ,p_CREATED_BY => FND_GLOBAL.User_Id

1311: ,p_OPP_LINE_ID => l_line_out_tbl(l_index).lead_line_id
1312: ,p_LAST_UPDATE_DATE => SYSDATE
1313: ,p_LAST_UPDATED_BY => FND_GLOBAL.User_Id
1314: ,p_CREATION_DATE => SYSDATE
1315: ,p_CREATED_BY => FND_GLOBAL.User_Id
1316: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.Conc_Login_Id
1317: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
1318: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id
1319: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id

Line 1316: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.Conc_Login_Id

1312: ,p_LAST_UPDATE_DATE => SYSDATE
1313: ,p_LAST_UPDATED_BY => FND_GLOBAL.User_Id
1314: ,p_CREATION_DATE => SYSDATE
1315: ,p_CREATED_BY => FND_GLOBAL.User_Id
1316: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.Conc_Login_Id
1317: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
1318: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id
1319: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id
1320: ,p_PROGRAM_UPDATE_DATE => SYSDATE

Line 1317: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id

1313: ,p_LAST_UPDATED_BY => FND_GLOBAL.User_Id
1314: ,p_CREATION_DATE => SYSDATE
1315: ,p_CREATED_BY => FND_GLOBAL.User_Id
1316: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.Conc_Login_Id
1317: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
1318: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id
1319: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id
1320: ,p_PROGRAM_UPDATE_DATE => SYSDATE
1321: ,p_ATTRIBUTE_CATEGORY => l_line_tbl(l_index).attribute_category

Line 1318: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id

1314: ,p_CREATION_DATE => SYSDATE
1315: ,p_CREATED_BY => FND_GLOBAL.User_Id
1316: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.Conc_Login_Id
1317: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
1318: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id
1319: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id
1320: ,p_PROGRAM_UPDATE_DATE => SYSDATE
1321: ,p_ATTRIBUTE_CATEGORY => l_line_tbl(l_index).attribute_category
1322: ,p_ATTRIBUTE1 => l_line_tbl(l_index).attribute1

Line 1319: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id

1315: ,p_CREATED_BY => FND_GLOBAL.User_Id
1316: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.Conc_Login_Id
1317: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
1318: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id
1319: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id
1320: ,p_PROGRAM_UPDATE_DATE => SYSDATE
1321: ,p_ATTRIBUTE_CATEGORY => l_line_tbl(l_index).attribute_category
1322: ,p_ATTRIBUTE1 => l_line_tbl(l_index).attribute1
1323: ,p_ATTRIBUTE2 => l_line_tbl(l_index).attribute2

Line 1370: l_contact_tbl(l_cnt).last_updated_by := FND_GLOBAL.USER_ID;

1366: l_contact_tbl(l_cnt).contact_id := C_SL_Contacts_Rec.contact_id;
1367: l_contact_tbl(l_cnt).contact_party_id
1368: := C_SL_Contacts_Rec.contact_party_id;
1369: l_contact_tbl(l_cnt).last_update_date := SYSDATE;
1370: l_contact_tbl(l_cnt).last_updated_by := FND_GLOBAL.USER_ID;
1371: l_contact_tbl(l_cnt).creation_Date := SYSDATE;
1372: l_contact_tbl(l_cnt).created_by := FND_GLOBAL.USER_ID;
1373: l_contact_tbl(l_cnt).last_update_login :=FND_GLOBAL.CONC_LOGIN_ID;
1374: l_contact_tbl(l_cnt).enabled_flag:=C_SL_Contacts_Rec.enabled_flag;

Line 1372: l_contact_tbl(l_cnt).created_by := FND_GLOBAL.USER_ID;

1368: := C_SL_Contacts_Rec.contact_party_id;
1369: l_contact_tbl(l_cnt).last_update_date := SYSDATE;
1370: l_contact_tbl(l_cnt).last_updated_by := FND_GLOBAL.USER_ID;
1371: l_contact_tbl(l_cnt).creation_Date := SYSDATE;
1372: l_contact_tbl(l_cnt).created_by := FND_GLOBAL.USER_ID;
1373: l_contact_tbl(l_cnt).last_update_login :=FND_GLOBAL.CONC_LOGIN_ID;
1374: l_contact_tbl(l_cnt).enabled_flag:=C_SL_Contacts_Rec.enabled_flag;
1375: l_contact_tbl(l_cnt).customer_id := C_SL_Contacts_Rec.customer_id;
1376: l_contact_tbl(l_cnt).address_id := C_SL_Contacts_Rec.address_id;

Line 1373: l_contact_tbl(l_cnt).last_update_login :=FND_GLOBAL.CONC_LOGIN_ID;

1369: l_contact_tbl(l_cnt).last_update_date := SYSDATE;
1370: l_contact_tbl(l_cnt).last_updated_by := FND_GLOBAL.USER_ID;
1371: l_contact_tbl(l_cnt).creation_Date := SYSDATE;
1372: l_contact_tbl(l_cnt).created_by := FND_GLOBAL.USER_ID;
1373: l_contact_tbl(l_cnt).last_update_login :=FND_GLOBAL.CONC_LOGIN_ID;
1374: l_contact_tbl(l_cnt).enabled_flag:=C_SL_Contacts_Rec.enabled_flag;
1375: l_contact_tbl(l_cnt).customer_id := C_SL_Contacts_Rec.customer_id;
1376: l_contact_tbl(l_cnt).address_id := C_SL_Contacts_Rec.address_id;
1377: l_contact_tbl(l_cnt).phone_id := C_SL_Contacts_Rec.phone_id;

Line 1485: ,p_LAST_UPDATED_BY => FND_GLOBAL.User_Id

1481: px_LEAD_OPPORTUNITY_ID => l_Lead_Opportunity_Id
1482: ,p_SALES_LEAD_ID => P_Sales_Lead_Id
1483: ,p_OPPORTUNITY_ID => P_Opportunity_Id
1484: ,p_LAST_UPDATE_DATE => SYSDATE
1485: ,p_LAST_UPDATED_BY => FND_GLOBAL.User_Id
1486: ,p_CREATION_DATE => SYSDATE
1487: ,p_CREATED_BY => FND_GLOBAL.User_Id
1488: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.Conc_Login_Id
1489: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id

Line 1487: ,p_CREATED_BY => FND_GLOBAL.User_Id

1483: ,p_OPPORTUNITY_ID => P_Opportunity_Id
1484: ,p_LAST_UPDATE_DATE => SYSDATE
1485: ,p_LAST_UPDATED_BY => FND_GLOBAL.User_Id
1486: ,p_CREATION_DATE => SYSDATE
1487: ,p_CREATED_BY => FND_GLOBAL.User_Id
1488: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.Conc_Login_Id
1489: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
1490: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id
1491: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id

Line 1488: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.Conc_Login_Id

1484: ,p_LAST_UPDATE_DATE => SYSDATE
1485: ,p_LAST_UPDATED_BY => FND_GLOBAL.User_Id
1486: ,p_CREATION_DATE => SYSDATE
1487: ,p_CREATED_BY => FND_GLOBAL.User_Id
1488: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.Conc_Login_Id
1489: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
1490: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id
1491: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id
1492: ,p_PROGRAM_UPDATE_DATE => SYSDATE

Line 1489: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id

1485: ,p_LAST_UPDATED_BY => FND_GLOBAL.User_Id
1486: ,p_CREATION_DATE => SYSDATE
1487: ,p_CREATED_BY => FND_GLOBAL.User_Id
1488: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.Conc_Login_Id
1489: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
1490: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id
1491: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id
1492: ,p_PROGRAM_UPDATE_DATE => SYSDATE
1493: ,p_ATTRIBUTE_CATEGORY => l_header_rec.attribute_category

Line 1490: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id

1486: ,p_CREATION_DATE => SYSDATE
1487: ,p_CREATED_BY => FND_GLOBAL.User_Id
1488: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.Conc_Login_Id
1489: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
1490: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id
1491: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id
1492: ,p_PROGRAM_UPDATE_DATE => SYSDATE
1493: ,p_ATTRIBUTE_CATEGORY => l_header_rec.attribute_category
1494: ,p_ATTRIBUTE1 => l_header_rec.attribute1

Line 1491: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id

1487: ,p_CREATED_BY => FND_GLOBAL.User_Id
1488: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.Conc_Login_Id
1489: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
1490: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id
1491: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id
1492: ,p_PROGRAM_UPDATE_DATE => SYSDATE
1493: ,p_ATTRIBUTE_CATEGORY => l_header_rec.attribute_category
1494: ,p_ATTRIBUTE1 => l_header_rec.attribute1
1495: ,p_ATTRIBUTE2 => l_header_rec.attribute2

Line 1806: IF FND_GLOBAL.User_Id IS NULL

1802: -- Validate Environment
1803: -- ******************************************************************
1804:
1805:
1806: IF FND_GLOBAL.User_Id IS NULL
1807: THEN
1808: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1809: THEN
1810: AS_UTILITY_PVT.Set_Message(

Line 2141: ,p_LAST_UPDATED_BY => FND_GLOBAL.User_Id

2137: px_LEAD_OPPORTUNITY_ID => l_Lead_Opportunity_Id
2138: ,p_SALES_LEAD_ID => P_Sales_Lead_Id
2139: ,p_OPPORTUNITY_ID => P_Opportunity_Id
2140: ,p_LAST_UPDATE_DATE => SYSDATE
2141: ,p_LAST_UPDATED_BY => FND_GLOBAL.User_Id
2142: ,p_CREATION_DATE => SYSDATE
2143: ,p_CREATED_BY => FND_GLOBAL.User_Id
2144: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.Conc_Login_Id
2145: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id

Line 2143: ,p_CREATED_BY => FND_GLOBAL.User_Id

2139: ,p_OPPORTUNITY_ID => P_Opportunity_Id
2140: ,p_LAST_UPDATE_DATE => SYSDATE
2141: ,p_LAST_UPDATED_BY => FND_GLOBAL.User_Id
2142: ,p_CREATION_DATE => SYSDATE
2143: ,p_CREATED_BY => FND_GLOBAL.User_Id
2144: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.Conc_Login_Id
2145: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
2146: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id
2147: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id

Line 2144: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.Conc_Login_Id

2140: ,p_LAST_UPDATE_DATE => SYSDATE
2141: ,p_LAST_UPDATED_BY => FND_GLOBAL.User_Id
2142: ,p_CREATION_DATE => SYSDATE
2143: ,p_CREATED_BY => FND_GLOBAL.User_Id
2144: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.Conc_Login_Id
2145: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
2146: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id
2147: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id
2148: ,p_PROGRAM_UPDATE_DATE => SYSDATE

Line 2145: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id

2141: ,p_LAST_UPDATED_BY => FND_GLOBAL.User_Id
2142: ,p_CREATION_DATE => SYSDATE
2143: ,p_CREATED_BY => FND_GLOBAL.User_Id
2144: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.Conc_Login_Id
2145: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
2146: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id
2147: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id
2148: ,p_PROGRAM_UPDATE_DATE => SYSDATE
2149: ,p_ATTRIBUTE_CATEGORY => l_header_rec.attribute_category

Line 2146: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id

2142: ,p_CREATION_DATE => SYSDATE
2143: ,p_CREATED_BY => FND_GLOBAL.User_Id
2144: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.Conc_Login_Id
2145: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
2146: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id
2147: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id
2148: ,p_PROGRAM_UPDATE_DATE => SYSDATE
2149: ,p_ATTRIBUTE_CATEGORY => l_header_rec.attribute_category
2150: ,p_ATTRIBUTE1 => l_header_rec.attribute1

Line 2147: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id

2143: ,p_CREATED_BY => FND_GLOBAL.User_Id
2144: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.Conc_Login_Id
2145: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
2146: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id
2147: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id
2148: ,p_PROGRAM_UPDATE_DATE => SYSDATE
2149: ,p_ATTRIBUTE_CATEGORY => l_header_rec.attribute_category
2150: ,p_ATTRIBUTE1 => l_header_rec.attribute1
2151: ,p_ATTRIBUTE2 => l_header_rec.attribute2

Line 2445: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

2441: SELECT 'X'
2442: FROM fnd_attached_documents
2443: WHERE pk1_value=X_Sales_Lead_Id;
2444: l_val_exists VARCHAR2(1) default null;
2445: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
2446: --Enhancement related Bug#3913225 @ @ Changes for ASN.B--End
2447: -- Start Bug#3966128
2448:
2449: CURSOR c_address_id(x_partner_party_id NUMBER) is

Line 2557: IF FND_GLOBAL.User_Id IS NULL

2553: --
2554: -- ******************************************************************
2555: -- Validate Environment
2556: -- ******************************************************************
2557: IF FND_GLOBAL.User_Id IS NULL
2558: THEN
2559: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2560: THEN
2561: AS_UTILITY_PVT.Set_Message(

Line 2781: -- l_header_rec.last_updated_by := FND_GLOBAL.USER_ID;

2777:
2778:
2779: -- Copy the sales lead information (header level) to opportunity
2780: -- l_header_rec.last_update_date := SYSDATE;
2781: -- l_header_rec.last_updated_by := FND_GLOBAL.USER_ID;
2782: -- l_header_rec.creation_Date := SYSDATE;
2783: -- l_header_rec.created_by := FND_GLOBAL.USER_ID;
2784: -- l_header_rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
2785: -- l_header_rec.lead_number := l_Sales_Lead_Rec.lead_number;

Line 2783: -- l_header_rec.created_by := FND_GLOBAL.USER_ID;

2779: -- Copy the sales lead information (header level) to opportunity
2780: -- l_header_rec.last_update_date := SYSDATE;
2781: -- l_header_rec.last_updated_by := FND_GLOBAL.USER_ID;
2782: -- l_header_rec.creation_Date := SYSDATE;
2783: -- l_header_rec.created_by := FND_GLOBAL.USER_ID;
2784: -- l_header_rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
2785: -- l_header_rec.lead_number := l_Sales_Lead_Rec.lead_number;
2786:
2787: -- ffang 121200 for bug 1529866: opportunity's status should be get from

Line 2784: -- l_header_rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;

2780: -- l_header_rec.last_update_date := SYSDATE;
2781: -- l_header_rec.last_updated_by := FND_GLOBAL.USER_ID;
2782: -- l_header_rec.creation_Date := SYSDATE;
2783: -- l_header_rec.created_by := FND_GLOBAL.USER_ID;
2784: -- l_header_rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
2785: -- l_header_rec.lead_number := l_Sales_Lead_Rec.lead_number;
2786:
2787: -- ffang 121200 for bug 1529866: opportunity's status should be get from
2788: -- p_opp_status.

Line 2938: l_line_tbl(l_cnt).last_updated_by := FND_GLOBAL.USER_ID;

2934: l_sales_lead_line_tbl(l_cnt).sales_lead_line_id
2935: := C_Sales_Lead_lines_Rec.sales_lead_line_id;
2936:
2937: l_line_tbl(l_cnt).last_update_date := SYSDATE;
2938: l_line_tbl(l_cnt).last_updated_by := FND_GLOBAL.USER_ID;
2939: l_line_tbl(l_cnt).creation_Date := SYSDATE;
2940: l_line_tbl(l_cnt).created_by := FND_GLOBAL.USER_ID;
2941: l_line_tbl(l_cnt).last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
2942: l_line_tbl(l_cnt).lead_id := l_lead_id;

Line 2940: l_line_tbl(l_cnt).created_by := FND_GLOBAL.USER_ID;

2936:
2937: l_line_tbl(l_cnt).last_update_date := SYSDATE;
2938: l_line_tbl(l_cnt).last_updated_by := FND_GLOBAL.USER_ID;
2939: l_line_tbl(l_cnt).creation_Date := SYSDATE;
2940: l_line_tbl(l_cnt).created_by := FND_GLOBAL.USER_ID;
2941: l_line_tbl(l_cnt).last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
2942: l_line_tbl(l_cnt).lead_id := l_lead_id;
2943: -- 103000 FFANG as_lead_lines_all.status_code has been obsolete
2944: -- l_line_tbl(l_cnt).status_code := 'NEW_OPPORTUNITY';

Line 2941: l_line_tbl(l_cnt).last_update_login := FND_GLOBAL.CONC_LOGIN_ID;

2937: l_line_tbl(l_cnt).last_update_date := SYSDATE;
2938: l_line_tbl(l_cnt).last_updated_by := FND_GLOBAL.USER_ID;
2939: l_line_tbl(l_cnt).creation_Date := SYSDATE;
2940: l_line_tbl(l_cnt).created_by := FND_GLOBAL.USER_ID;
2941: l_line_tbl(l_cnt).last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
2942: l_line_tbl(l_cnt).lead_id := l_lead_id;
2943: -- 103000 FFANG as_lead_lines_all.status_code has been obsolete
2944: -- l_line_tbl(l_cnt).status_code := 'NEW_OPPORTUNITY';
2945: -- end 103000 FFANG

Line 3053: ,p_LAST_UPDATED_BY => FND_GLOBAL.User_Id

3049: ,p_SALES_LEAD_LINE_ID =>
3050: l_sales_lead_line_tbl(l_index).sales_lead_line_id
3051: ,p_OPP_LINE_ID => l_line_out_tbl(l_index).lead_line_id
3052: ,p_LAST_UPDATE_DATE => SYSDATE
3053: ,p_LAST_UPDATED_BY => FND_GLOBAL.User_Id
3054: ,p_CREATION_DATE => SYSDATE
3055: ,p_CREATED_BY => FND_GLOBAL.User_Id
3056: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.Conc_Login_Id
3057: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id

Line 3055: ,p_CREATED_BY => FND_GLOBAL.User_Id

3051: ,p_OPP_LINE_ID => l_line_out_tbl(l_index).lead_line_id
3052: ,p_LAST_UPDATE_DATE => SYSDATE
3053: ,p_LAST_UPDATED_BY => FND_GLOBAL.User_Id
3054: ,p_CREATION_DATE => SYSDATE
3055: ,p_CREATED_BY => FND_GLOBAL.User_Id
3056: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.Conc_Login_Id
3057: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
3058: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id
3059: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id

Line 3056: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.Conc_Login_Id

3052: ,p_LAST_UPDATE_DATE => SYSDATE
3053: ,p_LAST_UPDATED_BY => FND_GLOBAL.User_Id
3054: ,p_CREATION_DATE => SYSDATE
3055: ,p_CREATED_BY => FND_GLOBAL.User_Id
3056: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.Conc_Login_Id
3057: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
3058: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id
3059: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id
3060: ,p_PROGRAM_UPDATE_DATE => SYSDATE

Line 3057: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id

3053: ,p_LAST_UPDATED_BY => FND_GLOBAL.User_Id
3054: ,p_CREATION_DATE => SYSDATE
3055: ,p_CREATED_BY => FND_GLOBAL.User_Id
3056: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.Conc_Login_Id
3057: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
3058: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id
3059: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id
3060: ,p_PROGRAM_UPDATE_DATE => SYSDATE
3061: ,p_ATTRIBUTE_CATEGORY => l_line_tbl(l_index).attribute_category

Line 3058: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id

3054: ,p_CREATION_DATE => SYSDATE
3055: ,p_CREATED_BY => FND_GLOBAL.User_Id
3056: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.Conc_Login_Id
3057: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
3058: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id
3059: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id
3060: ,p_PROGRAM_UPDATE_DATE => SYSDATE
3061: ,p_ATTRIBUTE_CATEGORY => l_line_tbl(l_index).attribute_category
3062: ,p_ATTRIBUTE1 => l_line_tbl(l_index).attribute1

Line 3059: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id

3055: ,p_CREATED_BY => FND_GLOBAL.User_Id
3056: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.Conc_Login_Id
3057: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
3058: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id
3059: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id
3060: ,p_PROGRAM_UPDATE_DATE => SYSDATE
3061: ,p_ATTRIBUTE_CATEGORY => l_line_tbl(l_index).attribute_category
3062: ,p_ATTRIBUTE1 => l_line_tbl(l_index).attribute1
3063: ,p_ATTRIBUTE2 => l_line_tbl(l_index).attribute2

Line 3099: l_contact_tbl(l_cnt).last_updated_by := FND_GLOBAL.USER_ID;

3095: l_contact_tbl(l_cnt).contact_id := C_SL_Contacts_Rec.contact_id;
3096: l_contact_tbl(l_cnt).contact_party_id
3097: := C_SL_Contacts_Rec.contact_party_id;
3098: l_contact_tbl(l_cnt).last_update_date := SYSDATE;
3099: l_contact_tbl(l_cnt).last_updated_by := FND_GLOBAL.USER_ID;
3100: l_contact_tbl(l_cnt).creation_Date := SYSDATE;
3101: l_contact_tbl(l_cnt).created_by := FND_GLOBAL.USER_ID;
3102: l_contact_tbl(l_cnt).last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
3103: l_contact_tbl(l_cnt).enabled_flag := C_SL_Contacts_Rec.enabled_flag;

Line 3101: l_contact_tbl(l_cnt).created_by := FND_GLOBAL.USER_ID;

3097: := C_SL_Contacts_Rec.contact_party_id;
3098: l_contact_tbl(l_cnt).last_update_date := SYSDATE;
3099: l_contact_tbl(l_cnt).last_updated_by := FND_GLOBAL.USER_ID;
3100: l_contact_tbl(l_cnt).creation_Date := SYSDATE;
3101: l_contact_tbl(l_cnt).created_by := FND_GLOBAL.USER_ID;
3102: l_contact_tbl(l_cnt).last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
3103: l_contact_tbl(l_cnt).enabled_flag := C_SL_Contacts_Rec.enabled_flag;
3104: l_contact_tbl(l_cnt).customer_id := C_SL_Contacts_Rec.customer_id;
3105: l_contact_tbl(l_cnt).address_id := C_SL_Contacts_Rec.address_id;

Line 3102: l_contact_tbl(l_cnt).last_update_login := FND_GLOBAL.CONC_LOGIN_ID;

3098: l_contact_tbl(l_cnt).last_update_date := SYSDATE;
3099: l_contact_tbl(l_cnt).last_updated_by := FND_GLOBAL.USER_ID;
3100: l_contact_tbl(l_cnt).creation_Date := SYSDATE;
3101: l_contact_tbl(l_cnt).created_by := FND_GLOBAL.USER_ID;
3102: l_contact_tbl(l_cnt).last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
3103: l_contact_tbl(l_cnt).enabled_flag := C_SL_Contacts_Rec.enabled_flag;
3104: l_contact_tbl(l_cnt).customer_id := C_SL_Contacts_Rec.customer_id;
3105: l_contact_tbl(l_cnt).address_id := C_SL_Contacts_Rec.address_id;
3106: l_contact_tbl(l_cnt).phone_id := C_SL_Contacts_Rec.phone_id;

Line 3235: ,p_LAST_UPDATED_BY => FND_GLOBAL.User_Id

3231: px_LEAD_OPPORTUNITY_ID => l_Lead_Opportunity_Id
3232: ,p_SALES_LEAD_ID => P_Sales_Lead_Id
3233: ,p_OPPORTUNITY_ID => l_Lead_Id
3234: ,p_LAST_UPDATE_DATE => SYSDATE
3235: ,p_LAST_UPDATED_BY => FND_GLOBAL.User_Id
3236: ,p_CREATION_DATE => SYSDATE
3237: ,p_CREATED_BY => FND_GLOBAL.User_Id
3238: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.Conc_Login_Id
3239: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id

Line 3237: ,p_CREATED_BY => FND_GLOBAL.User_Id

3233: ,p_OPPORTUNITY_ID => l_Lead_Id
3234: ,p_LAST_UPDATE_DATE => SYSDATE
3235: ,p_LAST_UPDATED_BY => FND_GLOBAL.User_Id
3236: ,p_CREATION_DATE => SYSDATE
3237: ,p_CREATED_BY => FND_GLOBAL.User_Id
3238: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.Conc_Login_Id
3239: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
3240: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id
3241: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id

Line 3238: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.Conc_Login_Id

3234: ,p_LAST_UPDATE_DATE => SYSDATE
3235: ,p_LAST_UPDATED_BY => FND_GLOBAL.User_Id
3236: ,p_CREATION_DATE => SYSDATE
3237: ,p_CREATED_BY => FND_GLOBAL.User_Id
3238: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.Conc_Login_Id
3239: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
3240: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id
3241: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id
3242: ,p_PROGRAM_UPDATE_DATE => SYSDATE

Line 3239: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id

3235: ,p_LAST_UPDATED_BY => FND_GLOBAL.User_Id
3236: ,p_CREATION_DATE => SYSDATE
3237: ,p_CREATED_BY => FND_GLOBAL.User_Id
3238: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.Conc_Login_Id
3239: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
3240: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id
3241: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id
3242: ,p_PROGRAM_UPDATE_DATE => SYSDATE
3243: ,p_ATTRIBUTE_CATEGORY => l_header_rec.attribute_category

Line 3240: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id

3236: ,p_CREATION_DATE => SYSDATE
3237: ,p_CREATED_BY => FND_GLOBAL.User_Id
3238: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.Conc_Login_Id
3239: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
3240: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id
3241: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id
3242: ,p_PROGRAM_UPDATE_DATE => SYSDATE
3243: ,p_ATTRIBUTE_CATEGORY => l_header_rec.attribute_category
3244: ,p_ATTRIBUTE1 => l_header_rec.attribute1

Line 3241: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id

3237: ,p_CREATED_BY => FND_GLOBAL.User_Id
3238: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.Conc_Login_Id
3239: ,p_REQUEST_ID => FND_GLOBAL.Conc_Request_Id
3240: ,p_PROGRAM_APPLICATION_ID => FND_GLOBAL.Prog_Appl_Id
3241: ,p_PROGRAM_ID => FND_GLOBAL.Conc_Program_Id
3242: ,p_PROGRAM_UPDATE_DATE => SYSDATE
3243: ,p_ATTRIBUTE_CATEGORY => l_header_rec.attribute_category
3244: ,p_ATTRIBUTE1 => l_header_rec.attribute1
3245: ,p_ATTRIBUTE2 => l_header_rec.attribute2

Line 3536: FND_GLOBAL.USER_ID,

3532: notes_rec.jtf_note_id ,
3533: 'OPPORTUNITY'
3534: ,p_opportunity_id,
3535: SYSDATE,
3536: FND_GLOBAL.USER_ID,
3537: SYSDATE,
3538: FND_GLOBAL.USER_ID,
3539: FND_GLOBAL.USER_ID);
3540:

Line 3538: FND_GLOBAL.USER_ID,

3534: ,p_opportunity_id,
3535: SYSDATE,
3536: FND_GLOBAL.USER_ID,
3537: SYSDATE,
3538: FND_GLOBAL.USER_ID,
3539: FND_GLOBAL.USER_ID);
3540:
3541: End Loop;
3542:

Line 3539: FND_GLOBAL.USER_ID);

3535: SYSDATE,
3536: FND_GLOBAL.USER_ID,
3537: SYSDATE,
3538: FND_GLOBAL.USER_ID,
3539: FND_GLOBAL.USER_ID);
3540:
3541: End Loop;
3542:
3543: EXCEPTION