DBA Data[Home] [Help]

APPS.AS_SALES_LEAD_RANKS_PVT dependencies on FND_GLOBAL

Line 13: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;

9:
10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AS_SALES_LEAD_RANKS_PVT';
11: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asxvrnkb.pls';
12: /*
13: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
14: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
15: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
16: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
17: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;

Line 14: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;

10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AS_SALES_LEAD_RANKS_PVT';
11: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asxvrnkb.pls';
12: /*
13: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
14: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
15: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
16: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
17: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
18: G_VERSION_NUM NUMBER := 1.0;

Line 15: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;

11: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asxvrnkb.pls';
12: /*
13: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
14: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
15: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
16: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
17: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
18: G_VERSION_NUM NUMBER := 1.0;
19: */

Line 16: G_USER_ID NUMBER := FND_GLOBAL.User_Id;

12: /*
13: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
14: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
15: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
16: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
17: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
18: G_VERSION_NUM NUMBER := 1.0;
19: */
20:

Line 17: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;

13: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
14: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
15: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
16: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
17: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
18: G_VERSION_NUM NUMBER := 1.0;
19: */
20:
21: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

Line 541: x_created_by => FND_GLOBAL.user_id,

537: x_enabled_flag => l_sales_lead_rank_rec.enabled_flag,
538: x_meaning => l_sales_lead_rank_rec.meaning,
539: x_description => l_sales_lead_rank_rec.description,
540: x_creation_date => sysdate,
541: x_created_by => FND_GLOBAL.user_id,
542: X_LAST_UPDATE_DATE => sysdate,
543: X_LAST_UPDATED_BY => FND_GLOBAL.user_id,
544: X_LAST_UPDATE_LOGIN => FND_GLOBAL.user_id
545: );

Line 543: X_LAST_UPDATED_BY => FND_GLOBAL.user_id,

539: x_description => l_sales_lead_rank_rec.description,
540: x_creation_date => sysdate,
541: x_created_by => FND_GLOBAL.user_id,
542: X_LAST_UPDATE_DATE => sysdate,
543: X_LAST_UPDATED_BY => FND_GLOBAL.user_id,
544: X_LAST_UPDATE_LOGIN => FND_GLOBAL.user_id
545: );
546: x_sales_lead_rank_id := l_sales_lead_rank_rec.rank_id;
547: --dbms_output.put_line('private API returns ' || x_return_status);

Line 544: X_LAST_UPDATE_LOGIN => FND_GLOBAL.user_id

540: x_creation_date => sysdate,
541: x_created_by => FND_GLOBAL.user_id,
542: X_LAST_UPDATE_DATE => sysdate,
543: X_LAST_UPDATED_BY => FND_GLOBAL.user_id,
544: X_LAST_UPDATE_LOGIN => FND_GLOBAL.user_id
545: );
546: x_sales_lead_rank_id := l_sales_lead_rank_rec.rank_id;
547: --dbms_output.put_line('private API returns ' || x_return_status);
548:

Line 786: X_LAST_UPDATED_BY => FND_GLOBAL.user_id,

782: x_enabled_flag => l_sales_lead_rank_rec.enabled_flag,
783: x_meaning => l_sales_lead_rank_rec.meaning,
784: x_description => l_sales_lead_rank_rec.description,
785: X_LAST_UPDATE_DATE => sysdate,
786: X_LAST_UPDATED_BY => FND_GLOBAL.user_id,
787: X_LAST_UPDATE_LOGIN => FND_GLOBAL.user_id
788: );
789:
790: IF l_min_score <> p_sales_lead_rank_rec.min_score

Line 787: X_LAST_UPDATE_LOGIN => FND_GLOBAL.user_id

783: x_meaning => l_sales_lead_rank_rec.meaning,
784: x_description => l_sales_lead_rank_rec.description,
785: X_LAST_UPDATE_DATE => sysdate,
786: X_LAST_UPDATED_BY => FND_GLOBAL.user_id,
787: X_LAST_UPDATE_LOGIN => FND_GLOBAL.user_id
788: );
789:
790: IF l_min_score <> p_sales_lead_rank_rec.min_score
791: THEN

Line 1031: , sl.last_updated_by = fnd_global.user_id

1027: Write_log (1, 'Updating the as_sales_leads.lead_rank_score');
1028: UPDATE as_sales_leads sl
1029: SET sl.lead_rank_score = x_lead_rank_score
1030: , sl.last_update_date = sysdate
1031: , sl.last_updated_by = fnd_global.user_id
1032: , sl.last_update_login = fnd_global.conc_login_id
1033: WHERE sl.lead_rank_id = x_lead_rank_id;
1034:
1035: --Update the as_accesses_all.lead_rank_score

Line 1032: , sl.last_update_login = fnd_global.conc_login_id

1028: UPDATE as_sales_leads sl
1029: SET sl.lead_rank_score = x_lead_rank_score
1030: , sl.last_update_date = sysdate
1031: , sl.last_updated_by = fnd_global.user_id
1032: , sl.last_update_login = fnd_global.conc_login_id
1033: WHERE sl.lead_rank_id = x_lead_rank_id;
1034:
1035: --Update the as_accesses_all.lead_rank_score
1036: Write_log (1, 'Updating the as_accesses_all.lead_rank_score');

Line 1040: , acc.last_updated_by = fnd_global.user_id

1036: Write_log (1, 'Updating the as_accesses_all.lead_rank_score');
1037: UPDATE AS_ACCESSES_ALL acc
1038: SET acc.lead_rank_score = x_lead_rank_score
1039: , acc.last_update_date = sysdate
1040: , acc.last_updated_by = fnd_global.user_id
1041: , acc.last_update_login = fnd_global.conc_login_id
1042: WHERE acc.sales_lead_id IN
1043: (select sl.sales_lead_id
1044: from as_sales_leads sl

Line 1041: , acc.last_update_login = fnd_global.conc_login_id

1037: UPDATE AS_ACCESSES_ALL acc
1038: SET acc.lead_rank_score = x_lead_rank_score
1039: , acc.last_update_date = sysdate
1040: , acc.last_updated_by = fnd_global.user_id
1041: , acc.last_update_login = fnd_global.conc_login_id
1042: WHERE acc.sales_lead_id IN
1043: (select sl.sales_lead_id
1044: from as_sales_leads sl
1045: where sl.lead_rank_id = x_lead_rank_id);