APPS.CSM_HTML5_PKG dependencies on ASG_USERS_INQARCHIVE

Line 2966: ' AND NOT EXISTS (SELECT 1 FROM asg_users_inqarchive ' ||

2962: 'SELECT pi_name FROM CSM_HTML5_INQ ci '||
2963: 'WHERE user_name = :1 AND ' ||
2964: ' sync_id = :2 AND ' ||
2965: ' pi_name in (select item_id from asg_pub_item) '||
2966: ' AND NOT EXISTS (SELECT 1 FROM asg_users_inqarchive ' ||
2967: ' WHERE device_user_name = ci.user_name AND TRANID =ci.sync_id) '||
2968: ' ORDER BY pi_name';
2969:
2970: l_cursor_id1 := DBMS_SQL.OPEN_CURSOR;

Line 3011: -- Replace with call to table-handler for asg_users_inqarchive

3007: counter2 := counter2 +1;
3008: END IF;
3009: END LOOP;
3010:
3011: -- Replace with call to table-handler for asg_users_inqarchive
3012: INSERT INTO asg_users_inqarchive (device_user_name,
3013: resource_id,
3014: tranid,
3015: sync_date,

Line 3012: INSERT INTO asg_users_inqarchive (device_user_name,

3008: END IF;
3009: END LOOP;
3010:
3011: -- Replace with call to table-handler for asg_users_inqarchive
3012: INSERT INTO asg_users_inqarchive (device_user_name,
3013: resource_id,
3014: tranid,
3015: sync_date,
3016: processed,

Line 3290: UPDATE asg_users_inqarchive

3286: curr_tran_processed := caau.processed;
3287: curr_tran_deferred := caau.deferred;
3288: curr_tran_archive := caau.archive;
3289: IF (curr_tran_processed = 'Y') AND (curr_tran_archive = 'Y') THEN
3290: UPDATE asg_users_inqarchive
3291: SET processed = 'Y', deferred = curr_tran_deferred,
3292: last_update_date = SYSDATE, last_updated_by = 1
3293: WHERE device_user_name = p_user_name AND
3294: tranid = curr_tranid;