APPS.AS_SALES_LEADS_LOG_PKG dependencies on FND_API

Line 56: if (px_log_id IS NULL) OR (px_log_id = FND_API.G_MISS_NUM) then

52: p_Prg_Update_Date DATE;
53: p_Prg_Appl_Id NUMBER;
54:
55: BEGIN
56: if (px_log_id IS NULL) OR (px_log_id = FND_API.G_MISS_NUM) then
57: OPEN C2;
58: FETCH C2 INTO px_log_id;
59: CLOSE C2;
60: end if;

Line 86: decode (p_sales_lead_id, fnd_api.g_miss_num, null, p_sales_lead_id),

82: CATEGORY,
83: MANUAL_RANK_FLAG
84: )
85: VALUES ( px_log_id,
86: decode (p_sales_lead_id, fnd_api.g_miss_num, null, p_sales_lead_id),
87: decode (p_created_by , fnd_api.g_miss_num, null, p_created_by),
88: decode (p_creation_date,fnd_api.g_miss_date, to_date(null), p_creation_date),
89: decode (p_last_updated_by, fnd_api.g_miss_num, null, p_last_updated_by),
90: decode (p_last_update_date , fnd_api.g_miss_date, to_date(null), p_last_update_date),

Line 87: decode (p_created_by , fnd_api.g_miss_num, null, p_created_by),

83: MANUAL_RANK_FLAG
84: )
85: VALUES ( px_log_id,
86: decode (p_sales_lead_id, fnd_api.g_miss_num, null, p_sales_lead_id),
87: decode (p_created_by , fnd_api.g_miss_num, null, p_created_by),
88: decode (p_creation_date,fnd_api.g_miss_date, to_date(null), p_creation_date),
89: decode (p_last_updated_by, fnd_api.g_miss_num, null, p_last_updated_by),
90: decode (p_last_update_date , fnd_api.g_miss_date, to_date(null), p_last_update_date),
91: decode (p_last_update_login , fnd_api.g_miss_num, null, p_last_update_login),

Line 88: decode (p_creation_date,fnd_api.g_miss_date, to_date(null), p_creation_date),

84: )
85: VALUES ( px_log_id,
86: decode (p_sales_lead_id, fnd_api.g_miss_num, null, p_sales_lead_id),
87: decode (p_created_by , fnd_api.g_miss_num, null, p_created_by),
88: decode (p_creation_date,fnd_api.g_miss_date, to_date(null), p_creation_date),
89: decode (p_last_updated_by, fnd_api.g_miss_num, null, p_last_updated_by),
90: decode (p_last_update_date , fnd_api.g_miss_date, to_date(null), p_last_update_date),
91: decode (p_last_update_login , fnd_api.g_miss_num, null, p_last_update_login),
92: decode (p_request_id , fnd_api.g_miss_num, null, p_request_id),

Line 89: decode (p_last_updated_by, fnd_api.g_miss_num, null, p_last_updated_by),

85: VALUES ( px_log_id,
86: decode (p_sales_lead_id, fnd_api.g_miss_num, null, p_sales_lead_id),
87: decode (p_created_by , fnd_api.g_miss_num, null, p_created_by),
88: decode (p_creation_date,fnd_api.g_miss_date, to_date(null), p_creation_date),
89: decode (p_last_updated_by, fnd_api.g_miss_num, null, p_last_updated_by),
90: decode (p_last_update_date , fnd_api.g_miss_date, to_date(null), p_last_update_date),
91: decode (p_last_update_login , fnd_api.g_miss_num, null, p_last_update_login),
92: decode (p_request_id , fnd_api.g_miss_num, null, p_request_id),
93: decode (p_program_application_id , fnd_api.g_miss_num, null,p_program_application_id),

Line 90: decode (p_last_update_date , fnd_api.g_miss_date, to_date(null), p_last_update_date),

86: decode (p_sales_lead_id, fnd_api.g_miss_num, null, p_sales_lead_id),
87: decode (p_created_by , fnd_api.g_miss_num, null, p_created_by),
88: decode (p_creation_date,fnd_api.g_miss_date, to_date(null), p_creation_date),
89: decode (p_last_updated_by, fnd_api.g_miss_num, null, p_last_updated_by),
90: decode (p_last_update_date , fnd_api.g_miss_date, to_date(null), p_last_update_date),
91: decode (p_last_update_login , fnd_api.g_miss_num, null, p_last_update_login),
92: decode (p_request_id , fnd_api.g_miss_num, null, p_request_id),
93: decode (p_program_application_id , fnd_api.g_miss_num, null,p_program_application_id),
94: decode (p_program_id , fnd_api.g_miss_num, null,p_program_id),

Line 91: decode (p_last_update_login , fnd_api.g_miss_num, null, p_last_update_login),

87: decode (p_created_by , fnd_api.g_miss_num, null, p_created_by),
88: decode (p_creation_date,fnd_api.g_miss_date, to_date(null), p_creation_date),
89: decode (p_last_updated_by, fnd_api.g_miss_num, null, p_last_updated_by),
90: decode (p_last_update_date , fnd_api.g_miss_date, to_date(null), p_last_update_date),
91: decode (p_last_update_login , fnd_api.g_miss_num, null, p_last_update_login),
92: decode (p_request_id , fnd_api.g_miss_num, null, p_request_id),
93: decode (p_program_application_id , fnd_api.g_miss_num, null,p_program_application_id),
94: decode (p_program_id , fnd_api.g_miss_num, null,p_program_id),
95: decode (p_program_update_date , fnd_api.g_miss_date, to_date(null),p_program_update_date),

Line 92: decode (p_request_id , fnd_api.g_miss_num, null, p_request_id),

88: decode (p_creation_date,fnd_api.g_miss_date, to_date(null), p_creation_date),
89: decode (p_last_updated_by, fnd_api.g_miss_num, null, p_last_updated_by),
90: decode (p_last_update_date , fnd_api.g_miss_date, to_date(null), p_last_update_date),
91: decode (p_last_update_login , fnd_api.g_miss_num, null, p_last_update_login),
92: decode (p_request_id , fnd_api.g_miss_num, null, p_request_id),
93: decode (p_program_application_id , fnd_api.g_miss_num, null,p_program_application_id),
94: decode (p_program_id , fnd_api.g_miss_num, null,p_program_id),
95: decode (p_program_update_date , fnd_api.g_miss_date, to_date(null),p_program_update_date),
96: decode (p_status_code , fnd_api.g_miss_char, null, p_status_code),

Line 93: decode (p_program_application_id , fnd_api.g_miss_num, null,p_program_application_id),

89: decode (p_last_updated_by, fnd_api.g_miss_num, null, p_last_updated_by),
90: decode (p_last_update_date , fnd_api.g_miss_date, to_date(null), p_last_update_date),
91: decode (p_last_update_login , fnd_api.g_miss_num, null, p_last_update_login),
92: decode (p_request_id , fnd_api.g_miss_num, null, p_request_id),
93: decode (p_program_application_id , fnd_api.g_miss_num, null,p_program_application_id),
94: decode (p_program_id , fnd_api.g_miss_num, null,p_program_id),
95: decode (p_program_update_date , fnd_api.g_miss_date, to_date(null),p_program_update_date),
96: decode (p_status_code , fnd_api.g_miss_char, null, p_status_code),
97: decode (p_assign_to_person_id , fnd_api.g_miss_num, null,p_assign_to_person_id),

Line 94: decode (p_program_id , fnd_api.g_miss_num, null,p_program_id),

90: decode (p_last_update_date , fnd_api.g_miss_date, to_date(null), p_last_update_date),
91: decode (p_last_update_login , fnd_api.g_miss_num, null, p_last_update_login),
92: decode (p_request_id , fnd_api.g_miss_num, null, p_request_id),
93: decode (p_program_application_id , fnd_api.g_miss_num, null,p_program_application_id),
94: decode (p_program_id , fnd_api.g_miss_num, null,p_program_id),
95: decode (p_program_update_date , fnd_api.g_miss_date, to_date(null),p_program_update_date),
96: decode (p_status_code , fnd_api.g_miss_char, null, p_status_code),
97: decode (p_assign_to_person_id , fnd_api.g_miss_num, null,p_assign_to_person_id),
98: decode (p_assign_to_salesforce_id , fnd_api.g_miss_num, null,p_assign_to_salesforce_id),

Line 95: decode (p_program_update_date , fnd_api.g_miss_date, to_date(null),p_program_update_date),

91: decode (p_last_update_login , fnd_api.g_miss_num, null, p_last_update_login),
92: decode (p_request_id , fnd_api.g_miss_num, null, p_request_id),
93: decode (p_program_application_id , fnd_api.g_miss_num, null,p_program_application_id),
94: decode (p_program_id , fnd_api.g_miss_num, null,p_program_id),
95: decode (p_program_update_date , fnd_api.g_miss_date, to_date(null),p_program_update_date),
96: decode (p_status_code , fnd_api.g_miss_char, null, p_status_code),
97: decode (p_assign_to_person_id , fnd_api.g_miss_num, null,p_assign_to_person_id),
98: decode (p_assign_to_salesforce_id , fnd_api.g_miss_num, null,p_assign_to_salesforce_id),
99: decode (p_reject_reason_code, fnd_api.g_miss_char, null,p_reject_reason_code),

Line 96: decode (p_status_code , fnd_api.g_miss_char, null, p_status_code),

92: decode (p_request_id , fnd_api.g_miss_num, null, p_request_id),
93: decode (p_program_application_id , fnd_api.g_miss_num, null,p_program_application_id),
94: decode (p_program_id , fnd_api.g_miss_num, null,p_program_id),
95: decode (p_program_update_date , fnd_api.g_miss_date, to_date(null),p_program_update_date),
96: decode (p_status_code , fnd_api.g_miss_char, null, p_status_code),
97: decode (p_assign_to_person_id , fnd_api.g_miss_num, null,p_assign_to_person_id),
98: decode (p_assign_to_salesforce_id , fnd_api.g_miss_num, null,p_assign_to_salesforce_id),
99: decode (p_reject_reason_code, fnd_api.g_miss_char, null,p_reject_reason_code),
100: decode (p_assign_sales_group_id, fnd_api.g_miss_num, null,p_assign_sales_group_id),

Line 97: decode (p_assign_to_person_id , fnd_api.g_miss_num, null,p_assign_to_person_id),

93: decode (p_program_application_id , fnd_api.g_miss_num, null,p_program_application_id),
94: decode (p_program_id , fnd_api.g_miss_num, null,p_program_id),
95: decode (p_program_update_date , fnd_api.g_miss_date, to_date(null),p_program_update_date),
96: decode (p_status_code , fnd_api.g_miss_char, null, p_status_code),
97: decode (p_assign_to_person_id , fnd_api.g_miss_num, null,p_assign_to_person_id),
98: decode (p_assign_to_salesforce_id , fnd_api.g_miss_num, null,p_assign_to_salesforce_id),
99: decode (p_reject_reason_code, fnd_api.g_miss_char, null,p_reject_reason_code),
100: decode (p_assign_sales_group_id, fnd_api.g_miss_num, null,p_assign_sales_group_id),
101: decode (p_lead_rank_id , fnd_api.g_miss_num, null,p_lead_rank_id),

Line 98: decode (p_assign_to_salesforce_id , fnd_api.g_miss_num, null,p_assign_to_salesforce_id),

94: decode (p_program_id , fnd_api.g_miss_num, null,p_program_id),
95: decode (p_program_update_date , fnd_api.g_miss_date, to_date(null),p_program_update_date),
96: decode (p_status_code , fnd_api.g_miss_char, null, p_status_code),
97: decode (p_assign_to_person_id , fnd_api.g_miss_num, null,p_assign_to_person_id),
98: decode (p_assign_to_salesforce_id , fnd_api.g_miss_num, null,p_assign_to_salesforce_id),
99: decode (p_reject_reason_code, fnd_api.g_miss_char, null,p_reject_reason_code),
100: decode (p_assign_sales_group_id, fnd_api.g_miss_num, null,p_assign_sales_group_id),
101: decode (p_lead_rank_id , fnd_api.g_miss_num, null,p_lead_rank_id),
102: decode (p_qualified_flag, fnd_api.g_miss_char, null,p_qualified_flag),

Line 99: decode (p_reject_reason_code, fnd_api.g_miss_char, null,p_reject_reason_code),

95: decode (p_program_update_date , fnd_api.g_miss_date, to_date(null),p_program_update_date),
96: decode (p_status_code , fnd_api.g_miss_char, null, p_status_code),
97: decode (p_assign_to_person_id , fnd_api.g_miss_num, null,p_assign_to_person_id),
98: decode (p_assign_to_salesforce_id , fnd_api.g_miss_num, null,p_assign_to_salesforce_id),
99: decode (p_reject_reason_code, fnd_api.g_miss_char, null,p_reject_reason_code),
100: decode (p_assign_sales_group_id, fnd_api.g_miss_num, null,p_assign_sales_group_id),
101: decode (p_lead_rank_id , fnd_api.g_miss_num, null,p_lead_rank_id),
102: decode (p_qualified_flag, fnd_api.g_miss_char, null,p_qualified_flag),
103: decode (p_category, fnd_api.g_miss_char, null,p_category),

Line 100: decode (p_assign_sales_group_id, fnd_api.g_miss_num, null,p_assign_sales_group_id),

96: decode (p_status_code , fnd_api.g_miss_char, null, p_status_code),
97: decode (p_assign_to_person_id , fnd_api.g_miss_num, null,p_assign_to_person_id),
98: decode (p_assign_to_salesforce_id , fnd_api.g_miss_num, null,p_assign_to_salesforce_id),
99: decode (p_reject_reason_code, fnd_api.g_miss_char, null,p_reject_reason_code),
100: decode (p_assign_sales_group_id, fnd_api.g_miss_num, null,p_assign_sales_group_id),
101: decode (p_lead_rank_id , fnd_api.g_miss_num, null,p_lead_rank_id),
102: decode (p_qualified_flag, fnd_api.g_miss_char, null,p_qualified_flag),
103: decode (p_category, fnd_api.g_miss_char, null,p_category),
104: decode (p_manual_rank_flag, fnd_api.g_miss_char, null,p_manual_rank_flag)

Line 101: decode (p_lead_rank_id , fnd_api.g_miss_num, null,p_lead_rank_id),

97: decode (p_assign_to_person_id , fnd_api.g_miss_num, null,p_assign_to_person_id),
98: decode (p_assign_to_salesforce_id , fnd_api.g_miss_num, null,p_assign_to_salesforce_id),
99: decode (p_reject_reason_code, fnd_api.g_miss_char, null,p_reject_reason_code),
100: decode (p_assign_sales_group_id, fnd_api.g_miss_num, null,p_assign_sales_group_id),
101: decode (p_lead_rank_id , fnd_api.g_miss_num, null,p_lead_rank_id),
102: decode (p_qualified_flag, fnd_api.g_miss_char, null,p_qualified_flag),
103: decode (p_category, fnd_api.g_miss_char, null,p_category),
104: decode (p_manual_rank_flag, fnd_api.g_miss_char, null,p_manual_rank_flag)
105:

Line 102: decode (p_qualified_flag, fnd_api.g_miss_char, null,p_qualified_flag),

98: decode (p_assign_to_salesforce_id , fnd_api.g_miss_num, null,p_assign_to_salesforce_id),
99: decode (p_reject_reason_code, fnd_api.g_miss_char, null,p_reject_reason_code),
100: decode (p_assign_sales_group_id, fnd_api.g_miss_num, null,p_assign_sales_group_id),
101: decode (p_lead_rank_id , fnd_api.g_miss_num, null,p_lead_rank_id),
102: decode (p_qualified_flag, fnd_api.g_miss_char, null,p_qualified_flag),
103: decode (p_category, fnd_api.g_miss_char, null,p_category),
104: decode (p_manual_rank_flag, fnd_api.g_miss_char, null,p_manual_rank_flag)
105:
106: );

Line 103: decode (p_category, fnd_api.g_miss_char, null,p_category),

99: decode (p_reject_reason_code, fnd_api.g_miss_char, null,p_reject_reason_code),
100: decode (p_assign_sales_group_id, fnd_api.g_miss_num, null,p_assign_sales_group_id),
101: decode (p_lead_rank_id , fnd_api.g_miss_num, null,p_lead_rank_id),
102: decode (p_qualified_flag, fnd_api.g_miss_char, null,p_qualified_flag),
103: decode (p_category, fnd_api.g_miss_char, null,p_category),
104: decode (p_manual_rank_flag, fnd_api.g_miss_char, null,p_manual_rank_flag)
105:
106: );
107:

Line 104: decode (p_manual_rank_flag, fnd_api.g_miss_char, null,p_manual_rank_flag)

100: decode (p_assign_sales_group_id, fnd_api.g_miss_num, null,p_assign_sales_group_id),
101: decode (p_lead_rank_id , fnd_api.g_miss_num, null,p_lead_rank_id),
102: decode (p_qualified_flag, fnd_api.g_miss_char, null,p_qualified_flag),
103: decode (p_category, fnd_api.g_miss_char, null,p_category),
104: decode (p_manual_rank_flag, fnd_api.g_miss_char, null,p_manual_rank_flag)
105:
106: );
107:
108:

Line 230: sales_lead_id = decode(p_sales_lead_id, FND_API.G_MISS_NUM, sales_lead_id, p_sales_lead_id),

226: ) IS
227: BEGIN
228: UPDATE AS_SALES_LEADS_LOG
229: SET
230: sales_lead_id = decode(p_sales_lead_id, FND_API.G_MISS_NUM, sales_lead_id, p_sales_lead_id),
231: last_update_date = decode(p_last_Update_Date, FND_API.G_MISS_DATE, last_update_date , p_last_update_date),
232: last_updated_by = decode(last_Updated_By, FND_API.G_MISS_NUM, last_updated_by, p_last_updated_by),
233: last_update_login = decode(last_Update_Login, FND_API.G_MISS_NUM, last_update_login, p_last_update_login),
234: request_id = decode(request_id , FND_API.G_MISS_NUM, request_id, p_request_id),

Line 231: last_update_date = decode(p_last_Update_Date, FND_API.G_MISS_DATE, last_update_date , p_last_update_date),

227: BEGIN
228: UPDATE AS_SALES_LEADS_LOG
229: SET
230: sales_lead_id = decode(p_sales_lead_id, FND_API.G_MISS_NUM, sales_lead_id, p_sales_lead_id),
231: last_update_date = decode(p_last_Update_Date, FND_API.G_MISS_DATE, last_update_date , p_last_update_date),
232: last_updated_by = decode(last_Updated_By, FND_API.G_MISS_NUM, last_updated_by, p_last_updated_by),
233: last_update_login = decode(last_Update_Login, FND_API.G_MISS_NUM, last_update_login, p_last_update_login),
234: request_id = decode(request_id , FND_API.G_MISS_NUM, request_id, p_request_id),
235: program_application_id = decode(program_application_id , FND_API.G_MISS_NUM, program_application_id, p_program_application_id),

Line 232: last_updated_by = decode(last_Updated_By, FND_API.G_MISS_NUM, last_updated_by, p_last_updated_by),

228: UPDATE AS_SALES_LEADS_LOG
229: SET
230: sales_lead_id = decode(p_sales_lead_id, FND_API.G_MISS_NUM, sales_lead_id, p_sales_lead_id),
231: last_update_date = decode(p_last_Update_Date, FND_API.G_MISS_DATE, last_update_date , p_last_update_date),
232: last_updated_by = decode(last_Updated_By, FND_API.G_MISS_NUM, last_updated_by, p_last_updated_by),
233: last_update_login = decode(last_Update_Login, FND_API.G_MISS_NUM, last_update_login, p_last_update_login),
234: request_id = decode(request_id , FND_API.G_MISS_NUM, request_id, p_request_id),
235: program_application_id = decode(program_application_id , FND_API.G_MISS_NUM, program_application_id, p_program_application_id),
236: program_id = decode(program_id , FND_API.G_MISS_NUM, program_id, p_program_id),

Line 233: last_update_login = decode(last_Update_Login, FND_API.G_MISS_NUM, last_update_login, p_last_update_login),

229: SET
230: sales_lead_id = decode(p_sales_lead_id, FND_API.G_MISS_NUM, sales_lead_id, p_sales_lead_id),
231: last_update_date = decode(p_last_Update_Date, FND_API.G_MISS_DATE, last_update_date , p_last_update_date),
232: last_updated_by = decode(last_Updated_By, FND_API.G_MISS_NUM, last_updated_by, p_last_updated_by),
233: last_update_login = decode(last_Update_Login, FND_API.G_MISS_NUM, last_update_login, p_last_update_login),
234: request_id = decode(request_id , FND_API.G_MISS_NUM, request_id, p_request_id),
235: program_application_id = decode(program_application_id , FND_API.G_MISS_NUM, program_application_id, p_program_application_id),
236: program_id = decode(program_id , FND_API.G_MISS_NUM, program_id, p_program_id),
237: program_update_date = decode(program_update_date , FND_API.G_MISS_DATE, program_update_date, p_program_update_date),

Line 234: request_id = decode(request_id , FND_API.G_MISS_NUM, request_id, p_request_id),

230: sales_lead_id = decode(p_sales_lead_id, FND_API.G_MISS_NUM, sales_lead_id, p_sales_lead_id),
231: last_update_date = decode(p_last_Update_Date, FND_API.G_MISS_DATE, last_update_date , p_last_update_date),
232: last_updated_by = decode(last_Updated_By, FND_API.G_MISS_NUM, last_updated_by, p_last_updated_by),
233: last_update_login = decode(last_Update_Login, FND_API.G_MISS_NUM, last_update_login, p_last_update_login),
234: request_id = decode(request_id , FND_API.G_MISS_NUM, request_id, p_request_id),
235: program_application_id = decode(program_application_id , FND_API.G_MISS_NUM, program_application_id, p_program_application_id),
236: program_id = decode(program_id , FND_API.G_MISS_NUM, program_id, p_program_id),
237: program_update_date = decode(program_update_date , FND_API.G_MISS_DATE, program_update_date, p_program_update_date),
238: status_code = decode(status_code , FND_API.G_MISS_CHAR, status_code, p_status_code),

Line 235: program_application_id = decode(program_application_id , FND_API.G_MISS_NUM, program_application_id, p_program_application_id),

231: last_update_date = decode(p_last_Update_Date, FND_API.G_MISS_DATE, last_update_date , p_last_update_date),
232: last_updated_by = decode(last_Updated_By, FND_API.G_MISS_NUM, last_updated_by, p_last_updated_by),
233: last_update_login = decode(last_Update_Login, FND_API.G_MISS_NUM, last_update_login, p_last_update_login),
234: request_id = decode(request_id , FND_API.G_MISS_NUM, request_id, p_request_id),
235: program_application_id = decode(program_application_id , FND_API.G_MISS_NUM, program_application_id, p_program_application_id),
236: program_id = decode(program_id , FND_API.G_MISS_NUM, program_id, p_program_id),
237: program_update_date = decode(program_update_date , FND_API.G_MISS_DATE, program_update_date, p_program_update_date),
238: status_code = decode(status_code , FND_API.G_MISS_CHAR, status_code, p_status_code),
239: assign_to_person_id = decode(assign_to_person_id , FND_API.G_MISS_NUM, assign_to_person_id, p_assign_to_person_id),

Line 236: program_id = decode(program_id , FND_API.G_MISS_NUM, program_id, p_program_id),

232: last_updated_by = decode(last_Updated_By, FND_API.G_MISS_NUM, last_updated_by, p_last_updated_by),
233: last_update_login = decode(last_Update_Login, FND_API.G_MISS_NUM, last_update_login, p_last_update_login),
234: request_id = decode(request_id , FND_API.G_MISS_NUM, request_id, p_request_id),
235: program_application_id = decode(program_application_id , FND_API.G_MISS_NUM, program_application_id, p_program_application_id),
236: program_id = decode(program_id , FND_API.G_MISS_NUM, program_id, p_program_id),
237: program_update_date = decode(program_update_date , FND_API.G_MISS_DATE, program_update_date, p_program_update_date),
238: status_code = decode(status_code , FND_API.G_MISS_CHAR, status_code, p_status_code),
239: assign_to_person_id = decode(assign_to_person_id , FND_API.G_MISS_NUM, assign_to_person_id, p_assign_to_person_id),
240: assign_to_salesforce_id = decode(assign_to_salesforce_id , FND_API.G_MISS_NUM, assign_to_salesforce_id, p_assign_to_salesforce_id),

Line 237: program_update_date = decode(program_update_date , FND_API.G_MISS_DATE, program_update_date, p_program_update_date),

233: last_update_login = decode(last_Update_Login, FND_API.G_MISS_NUM, last_update_login, p_last_update_login),
234: request_id = decode(request_id , FND_API.G_MISS_NUM, request_id, p_request_id),
235: program_application_id = decode(program_application_id , FND_API.G_MISS_NUM, program_application_id, p_program_application_id),
236: program_id = decode(program_id , FND_API.G_MISS_NUM, program_id, p_program_id),
237: program_update_date = decode(program_update_date , FND_API.G_MISS_DATE, program_update_date, p_program_update_date),
238: status_code = decode(status_code , FND_API.G_MISS_CHAR, status_code, p_status_code),
239: assign_to_person_id = decode(assign_to_person_id , FND_API.G_MISS_NUM, assign_to_person_id, p_assign_to_person_id),
240: assign_to_salesforce_id = decode(assign_to_salesforce_id , FND_API.G_MISS_NUM, assign_to_salesforce_id, p_assign_to_salesforce_id),
241: reject_reason_code = decode(reject_reason_code, FND_API.G_MISS_CHAR, reject_reason_code, p_reject_reason_code),

Line 238: status_code = decode(status_code , FND_API.G_MISS_CHAR, status_code, p_status_code),

234: request_id = decode(request_id , FND_API.G_MISS_NUM, request_id, p_request_id),
235: program_application_id = decode(program_application_id , FND_API.G_MISS_NUM, program_application_id, p_program_application_id),
236: program_id = decode(program_id , FND_API.G_MISS_NUM, program_id, p_program_id),
237: program_update_date = decode(program_update_date , FND_API.G_MISS_DATE, program_update_date, p_program_update_date),
238: status_code = decode(status_code , FND_API.G_MISS_CHAR, status_code, p_status_code),
239: assign_to_person_id = decode(assign_to_person_id , FND_API.G_MISS_NUM, assign_to_person_id, p_assign_to_person_id),
240: assign_to_salesforce_id = decode(assign_to_salesforce_id , FND_API.G_MISS_NUM, assign_to_salesforce_id, p_assign_to_salesforce_id),
241: reject_reason_code = decode(reject_reason_code, FND_API.G_MISS_CHAR, reject_reason_code, p_reject_reason_code),
242: assign_sales_group_id = decode(assign_sales_group_id, FND_API.G_MISS_NUM, assign_sales_group_id, p_assign_sales_group_id),

Line 239: assign_to_person_id = decode(assign_to_person_id , FND_API.G_MISS_NUM, assign_to_person_id, p_assign_to_person_id),

235: program_application_id = decode(program_application_id , FND_API.G_MISS_NUM, program_application_id, p_program_application_id),
236: program_id = decode(program_id , FND_API.G_MISS_NUM, program_id, p_program_id),
237: program_update_date = decode(program_update_date , FND_API.G_MISS_DATE, program_update_date, p_program_update_date),
238: status_code = decode(status_code , FND_API.G_MISS_CHAR, status_code, p_status_code),
239: assign_to_person_id = decode(assign_to_person_id , FND_API.G_MISS_NUM, assign_to_person_id, p_assign_to_person_id),
240: assign_to_salesforce_id = decode(assign_to_salesforce_id , FND_API.G_MISS_NUM, assign_to_salesforce_id, p_assign_to_salesforce_id),
241: reject_reason_code = decode(reject_reason_code, FND_API.G_MISS_CHAR, reject_reason_code, p_reject_reason_code),
242: assign_sales_group_id = decode(assign_sales_group_id, FND_API.G_MISS_NUM, assign_sales_group_id, p_assign_sales_group_id),
243: lead_rank_id = decode(lead_rank_id , FND_API.G_MISS_NUM, lead_rank_id, p_lead_rank_id),

Line 240: assign_to_salesforce_id = decode(assign_to_salesforce_id , FND_API.G_MISS_NUM, assign_to_salesforce_id, p_assign_to_salesforce_id),

236: program_id = decode(program_id , FND_API.G_MISS_NUM, program_id, p_program_id),
237: program_update_date = decode(program_update_date , FND_API.G_MISS_DATE, program_update_date, p_program_update_date),
238: status_code = decode(status_code , FND_API.G_MISS_CHAR, status_code, p_status_code),
239: assign_to_person_id = decode(assign_to_person_id , FND_API.G_MISS_NUM, assign_to_person_id, p_assign_to_person_id),
240: assign_to_salesforce_id = decode(assign_to_salesforce_id , FND_API.G_MISS_NUM, assign_to_salesforce_id, p_assign_to_salesforce_id),
241: reject_reason_code = decode(reject_reason_code, FND_API.G_MISS_CHAR, reject_reason_code, p_reject_reason_code),
242: assign_sales_group_id = decode(assign_sales_group_id, FND_API.G_MISS_NUM, assign_sales_group_id, p_assign_sales_group_id),
243: lead_rank_id = decode(lead_rank_id , FND_API.G_MISS_NUM, lead_rank_id, p_lead_rank_id),
244: qualified_flag = decode(qualified_flag, FND_API.G_MISS_CHAR, qualified_flag, p_qualified_flag),

Line 241: reject_reason_code = decode(reject_reason_code, FND_API.G_MISS_CHAR, reject_reason_code, p_reject_reason_code),

237: program_update_date = decode(program_update_date , FND_API.G_MISS_DATE, program_update_date, p_program_update_date),
238: status_code = decode(status_code , FND_API.G_MISS_CHAR, status_code, p_status_code),
239: assign_to_person_id = decode(assign_to_person_id , FND_API.G_MISS_NUM, assign_to_person_id, p_assign_to_person_id),
240: assign_to_salesforce_id = decode(assign_to_salesforce_id , FND_API.G_MISS_NUM, assign_to_salesforce_id, p_assign_to_salesforce_id),
241: reject_reason_code = decode(reject_reason_code, FND_API.G_MISS_CHAR, reject_reason_code, p_reject_reason_code),
242: assign_sales_group_id = decode(assign_sales_group_id, FND_API.G_MISS_NUM, assign_sales_group_id, p_assign_sales_group_id),
243: lead_rank_id = decode(lead_rank_id , FND_API.G_MISS_NUM, lead_rank_id, p_lead_rank_id),
244: qualified_flag = decode(qualified_flag, FND_API.G_MISS_CHAR, qualified_flag, p_qualified_flag),
245: category = decode(category, FND_API.G_MISS_CHAR, category, p_category),

Line 242: assign_sales_group_id = decode(assign_sales_group_id, FND_API.G_MISS_NUM, assign_sales_group_id, p_assign_sales_group_id),

238: status_code = decode(status_code , FND_API.G_MISS_CHAR, status_code, p_status_code),
239: assign_to_person_id = decode(assign_to_person_id , FND_API.G_MISS_NUM, assign_to_person_id, p_assign_to_person_id),
240: assign_to_salesforce_id = decode(assign_to_salesforce_id , FND_API.G_MISS_NUM, assign_to_salesforce_id, p_assign_to_salesforce_id),
241: reject_reason_code = decode(reject_reason_code, FND_API.G_MISS_CHAR, reject_reason_code, p_reject_reason_code),
242: assign_sales_group_id = decode(assign_sales_group_id, FND_API.G_MISS_NUM, assign_sales_group_id, p_assign_sales_group_id),
243: lead_rank_id = decode(lead_rank_id , FND_API.G_MISS_NUM, lead_rank_id, p_lead_rank_id),
244: qualified_flag = decode(qualified_flag, FND_API.G_MISS_CHAR, qualified_flag, p_qualified_flag),
245: category = decode(category, FND_API.G_MISS_CHAR, category, p_category),
246: manual_rank_flag = decode(manual_rank_flag, FND_API.G_MISS_CHAR, manual_rank_flag, p_manual_rank_flag)

Line 243: lead_rank_id = decode(lead_rank_id , FND_API.G_MISS_NUM, lead_rank_id, p_lead_rank_id),

239: assign_to_person_id = decode(assign_to_person_id , FND_API.G_MISS_NUM, assign_to_person_id, p_assign_to_person_id),
240: assign_to_salesforce_id = decode(assign_to_salesforce_id , FND_API.G_MISS_NUM, assign_to_salesforce_id, p_assign_to_salesforce_id),
241: reject_reason_code = decode(reject_reason_code, FND_API.G_MISS_CHAR, reject_reason_code, p_reject_reason_code),
242: assign_sales_group_id = decode(assign_sales_group_id, FND_API.G_MISS_NUM, assign_sales_group_id, p_assign_sales_group_id),
243: lead_rank_id = decode(lead_rank_id , FND_API.G_MISS_NUM, lead_rank_id, p_lead_rank_id),
244: qualified_flag = decode(qualified_flag, FND_API.G_MISS_CHAR, qualified_flag, p_qualified_flag),
245: category = decode(category, FND_API.G_MISS_CHAR, category, p_category),
246: manual_rank_flag = decode(manual_rank_flag, FND_API.G_MISS_CHAR, manual_rank_flag, p_manual_rank_flag)
247:

Line 244: qualified_flag = decode(qualified_flag, FND_API.G_MISS_CHAR, qualified_flag, p_qualified_flag),

240: assign_to_salesforce_id = decode(assign_to_salesforce_id , FND_API.G_MISS_NUM, assign_to_salesforce_id, p_assign_to_salesforce_id),
241: reject_reason_code = decode(reject_reason_code, FND_API.G_MISS_CHAR, reject_reason_code, p_reject_reason_code),
242: assign_sales_group_id = decode(assign_sales_group_id, FND_API.G_MISS_NUM, assign_sales_group_id, p_assign_sales_group_id),
243: lead_rank_id = decode(lead_rank_id , FND_API.G_MISS_NUM, lead_rank_id, p_lead_rank_id),
244: qualified_flag = decode(qualified_flag, FND_API.G_MISS_CHAR, qualified_flag, p_qualified_flag),
245: category = decode(category, FND_API.G_MISS_CHAR, category, p_category),
246: manual_rank_flag = decode(manual_rank_flag, FND_API.G_MISS_CHAR, manual_rank_flag, p_manual_rank_flag)
247:
248: WHERE log_id = p_log_id;

Line 245: category = decode(category, FND_API.G_MISS_CHAR, category, p_category),

241: reject_reason_code = decode(reject_reason_code, FND_API.G_MISS_CHAR, reject_reason_code, p_reject_reason_code),
242: assign_sales_group_id = decode(assign_sales_group_id, FND_API.G_MISS_NUM, assign_sales_group_id, p_assign_sales_group_id),
243: lead_rank_id = decode(lead_rank_id , FND_API.G_MISS_NUM, lead_rank_id, p_lead_rank_id),
244: qualified_flag = decode(qualified_flag, FND_API.G_MISS_CHAR, qualified_flag, p_qualified_flag),
245: category = decode(category, FND_API.G_MISS_CHAR, category, p_category),
246: manual_rank_flag = decode(manual_rank_flag, FND_API.G_MISS_CHAR, manual_rank_flag, p_manual_rank_flag)
247:
248: WHERE log_id = p_log_id;
249:

Line 246: manual_rank_flag = decode(manual_rank_flag, FND_API.G_MISS_CHAR, manual_rank_flag, p_manual_rank_flag)

242: assign_sales_group_id = decode(assign_sales_group_id, FND_API.G_MISS_NUM, assign_sales_group_id, p_assign_sales_group_id),
243: lead_rank_id = decode(lead_rank_id , FND_API.G_MISS_NUM, lead_rank_id, p_lead_rank_id),
244: qualified_flag = decode(qualified_flag, FND_API.G_MISS_CHAR, qualified_flag, p_qualified_flag),
245: category = decode(category, FND_API.G_MISS_CHAR, category, p_category),
246: manual_rank_flag = decode(manual_rank_flag, FND_API.G_MISS_CHAR, manual_rank_flag, p_manual_rank_flag)
247:
248: WHERE log_id = p_log_id;
249:
250: if (SQL%NOTFOUND) then