APPS.PON_CONSOLE_PVT dependencies on PON_SUPPLIER_ACTIVITIES

Line 1189: l_last_activity_code pon_supplier_activities.last_activity_code%TYPE;

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

Line 1196: FROM pon_supplier_activities

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

Line 1231: UPDATE pon_supplier_activities

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

Line 1241: UPDATE pon_supplier_activities

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

Line 1263: INSERT INTO pon_supplier_activities

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