APPS.PON_CONSOLE_PVT dependencies on PON_SUPPLIER_ACTIVITIES

Line 1188: l_last_activity_code pon_supplier_activities.last_activity_code%TYPE;

1184: l_sysdate DATE;
1185: l_user_id NUMBER;
1186: l_login_id NUMBER;
1187:
1188: l_last_activity_code pon_supplier_activities.last_activity_code%TYPE;
1189: l_rowid ROWID;
1190: l_insert_flag VARCHAR2(1);
1191:
1192: CURSOR c_supplier_activity IS

Line 1195: FROM pon_supplier_activities

1191:
1192: CURSOR c_supplier_activity IS
1193: SELECT last_activity_code
1194: , rowid
1195: FROM pon_supplier_activities
1196: WHERE auction_header_id_orig_amend = p_auction_header_id_orig_amend
1197: AND trading_partner_id = p_trading_partner_id
1198: AND trading_partner_contact_id = p_trading_partner_contact_id
1199: AND last_action_flag = 'Y';

Line 1230: UPDATE pon_supplier_activities

1226: -- check activity codes are same and update the record.
1227: IF l_last_activity_code = p_last_activity_code THEN
1228: l_progress := '002';
1229: -- activities are same just update the activity time
1230: UPDATE pon_supplier_activities
1231: SET last_activity_time = l_sysdate
1232: , last_update_date = l_sysdate
1233: , last_updated_by = l_user_id
1234: , last_update_login = l_login_id

Line 1240: UPDATE pon_supplier_activities

1236: ELSE
1237: l_progress := '003';
1238: -- activities are different.
1239: -- disable previous record and set insert flag
1240: UPDATE pon_supplier_activities
1241: SET last_action_flag = 'N'
1242: , last_update_date = l_sysdate
1243: , last_updated_by = l_user_id
1244: , last_update_login = l_login_id

Line 1262: INSERT INTO pon_supplier_activities

1258:
1259: IF (l_insert_flag = 'Y') THEN
1260:
1261: l_progress := '006';
1262: INSERT INTO pon_supplier_activities
1263: ( auction_header_id
1264: , auction_header_id_orig_amend
1265: , trading_partner_id
1266: , trading_partner_contact_id