APPS.ASG_DEFER dependencies on ASG_USERS_INQINFO

Line 229: UPDATE asg_users_inqinfo

225: SYSDATE,
226: 1);
227:
228:
229: UPDATE asg_users_inqinfo
230: SET deferred = 'Y', processed = 'I',
231: last_update_date = SYSDATE, last_updated_by = 1
232: WHERE device_user_name = p_user_name AND
233: tranid = p_tranid;

Line 483: FROM asg_users_inqinfo

479: l_retcode VARCHAR2(1);
480: l_user_name VARCHAR2(100);
481: CURSOR c_isdeferred(p_user_name VARCHAR2, p_tranid NUMBER) IS
482: SELECT device_user_name
483: FROM asg_users_inqinfo
484: WHERE device_user_name = p_user_name AND
485: tranid = p_tranid AND
486: deferred <> 'N';
487: BEGIN

Line 569: UPDATE asg_users_inqinfo

565: return;
566: END IF;
567:
568: x_return_status := FND_API.G_RET_STS_SUCCESS;
569: UPDATE asg_users_inqinfo
570: SET deferred = 'D'
571: WHERE device_user_name = p_user_name AND
572: tranid = p_tranid;
573: COMMIT;

Line 608: UPDATE asg_users_inqinfo

604:
605: -- If All the deferred records are discarded
606: -- then set the state to discarded
607: IF l_def_count = 0 THEN
608: UPDATE asg_users_inqinfo
609: SET deferred = 'D'
610: WHERE device_user_name = p_user_name AND
611: tranid = p_tranid;
612: END IF;

Line 758: UPDATE asg_users_inqinfo

754: FETCH c_deferred_processed INTO l_def_count;
755: CLOSE c_deferred_processed;
756: -- All the deferred records are processed
757: IF l_def_count = 0 THEN
758: UPDATE asg_users_inqinfo
759: SET deferred = 'S'
760: WHERE device_user_name = p_user_name AND
761: tranid = p_tranid;
762: END IF;

Line 827: DELETE FROM asg_users_inqinfo

823: last_update_date = SYSDATE, last_updated_by = 1
824: WHERE device_user_name = p_user_name AND
825: tranid = p_tranid;
826:
827: DELETE FROM asg_users_inqinfo
828: WHERE device_user_name = p_user_name AND tranid = p_tranid;
829: COMMIT;
830: IF(asg_helper.check_is_log_enabled(g_stmt_level))
831: THEN

Line 837: -- Delete rows in asg_deferred_traninfo/asg_users_inqinfo with no data in INQ.

833: 'asg_defer',g_stmt_level);
834: END IF;
835: END purge_transaction;
836:
837: -- Delete rows in asg_deferred_traninfo/asg_users_inqinfo with no data in INQ.
838: PROCEDURE delete_deferred(p_status OUT NOCOPY VARCHAR2,
839: p_message OUT NOCOPY VARCHAR2)
840: IS
841: CURSOR c_deferred_lines

Line 905: DELETE FROM asg_users_inqinfo

901:
902: END LOOP;
903:
904: -- Delete any deferred headers
905: DELETE FROM asg_users_inqinfo
906: WHERE (device_user_name, tranid) NOT IN
907: (SELECT device_user_name, deferred_tran_id
908: FROM asg_deferred_traninfo);
909: