APPS.ASG_DEFER dependencies on ASG_USER

Line 99: FROM asg_user

95: PRAGMA AUTONOMOUS_TRANSACTION;
96: l_resource_id NUMBER;
97: CURSOR c_resource_id (p_user_name VARCHAR2) IS
98: SELECT resource_id
99: FROM asg_user
100: WHERE user_name = p_user_name;
101: l_error_msg VARCHAR2(4000);
102: l_msg_data VARCHAR2(2000);
103: l_msg_dummy NUMBER;

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 717: FROM asg_user

713: l_orig_resp_id := fnd_global.resp_id();
714: l_orig_app_id := fnd_global.resp_appl_id();
715:
716: SELECT user_id INTO l_user_id
717: FROM asg_user
718: WHERE user_name = p_user_name;
719:
720: SELECT responsibility_id, app_id INTO l_resp_id, l_app_id
721: FROM asg_user_pub_resps

Line 721: FROM asg_user_pub_resps

717: FROM asg_user
718: WHERE user_name = p_user_name;
719:
720: SELECT responsibility_id, app_id INTO l_resp_id, l_app_id
721: FROM asg_user_pub_resps
722: WHERE user_name = p_user_name AND
723: pub_name = l_pubname;
724:
725: fnd_global.apps_initialize(l_user_id, l_resp_id, l_app_id);

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 821: UPDATE asg_users_inqarchive

817: l_curr_pubitem, l_return_status);
818: END LOOP;
819: END IF;
820:
821: UPDATE asg_users_inqarchive
822: SET processed = 'Y', deferred = 'Y',
823: last_update_date = SYSDATE, last_updated_by = 1
824: WHERE device_user_name = p_user_name AND
825: tranid = p_tranid;

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: