APPS.ASG_DEFER dependencies on ASG_USER

Line 96: FROM asg_user

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

Line 221: UPDATE asg_users_inqinfo

217: SYSDATE,
218: 1,
219: SYSDATE,
220: 1);
221: UPDATE asg_users_inqinfo
222: SET deferred = 'Y', processed = 'I',
223: last_update_date = SYSDATE, last_updated_by = 1
224: WHERE device_user_name = p_user_name AND
225: tranid = p_tranid;

Line 463: FROM asg_users_inqinfo

459: l_retcode VARCHAR2(1);
460: l_user_name VARCHAR2(30);
461: CURSOR c_isdeferred(p_user_name VARCHAR2, p_tranid NUMBER) IS
462: SELECT device_user_name
463: FROM asg_users_inqinfo
464: WHERE device_user_name = p_user_name AND
465: tranid = p_tranid AND
466: deferred <> 'N';
467: BEGIN

Line 549: UPDATE asg_users_inqinfo

545: return;
546: END IF;
547:
548: x_return_status := FND_API.G_RET_STS_SUCCESS;
549: UPDATE asg_users_inqinfo
550: SET deferred = 'D'
551: WHERE device_user_name = p_user_name AND
552: tranid = p_tranid;
553: COMMIT;

Line 587: UPDATE asg_users_inqinfo

583:
584: -- If All the deferred records are discarded
585: -- then set the state to discarded
586: IF l_def_count = 0 THEN
587: UPDATE asg_users_inqinfo
588: SET deferred = 'D'
589: WHERE device_user_name = p_user_name AND
590: tranid = p_tranid;
591: END IF;

Line 688: FROM asg_user

684: l_orig_resp_id := fnd_global.resp_id();
685: l_orig_app_id := fnd_global.resp_appl_id();
686:
687: SELECT user_id INTO l_user_id
688: FROM asg_user
689: WHERE user_name = p_user_name;
690:
691: SELECT responsibility_id, app_id INTO l_resp_id, l_app_id
692: FROM asg_user_pub_resps

Line 692: FROM asg_user_pub_resps

688: FROM asg_user
689: WHERE user_name = p_user_name;
690:
691: SELECT responsibility_id, app_id INTO l_resp_id, l_app_id
692: FROM asg_user_pub_resps
693: WHERE user_name = p_user_name AND
694: pub_name = l_pubname;
695:
696: fnd_global.apps_initialize(l_user_id, l_resp_id, l_app_id);

Line 729: UPDATE asg_users_inqinfo

725: FETCH c_deferred_processed INTO l_def_count;
726: CLOSE c_deferred_processed;
727: -- All the deferred records are processed
728: IF l_def_count = 0 THEN
729: UPDATE asg_users_inqinfo
730: SET deferred = 'S'
731: WHERE device_user_name = p_user_name AND
732: tranid = p_tranid;
733: END IF;

Line 789: UPDATE asg_users_inqarchive

785: l_curr_pubitem, l_return_status);
786: END LOOP;
787: END IF;
788:
789: UPDATE asg_users_inqarchive
790: SET processed = 'Y', deferred = 'Y',
791: last_update_date = SYSDATE, last_updated_by = 1
792: WHERE device_user_name = p_user_name AND
793: tranid = p_tranid;

Line 795: DELETE FROM asg_users_inqinfo

791: last_update_date = SYSDATE, last_updated_by = 1
792: WHERE device_user_name = p_user_name AND
793: tranid = p_tranid;
794:
795: DELETE FROM asg_users_inqinfo
796: WHERE device_user_name = p_user_name AND tranid = p_tranid;
797: COMMIT;
798: IF(asg_helper.check_is_log_enabled(g_stmt_level))
799: THEN

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

801: 'asg_defer',g_stmt_level);
802: END IF;
803: END purge_transaction;
804:
805: -- Delete rows in asg_deferred_traninfo/asg_users_inqinfo with no data in INQ.
806: PROCEDURE delete_deferred(p_status OUT NOCOPY VARCHAR2,
807: p_message OUT NOCOPY VARCHAR2)
808: IS
809: CURSOR c_deferred_lines

Line 857: DELETE FROM asg_users_inqinfo

853:
854: END LOOP;
855:
856: -- Delete any deferred headers
857: DELETE FROM asg_users_inqinfo
858: WHERE (device_user_name, tranid) NOT IN
859: (SELECT device_user_name, deferred_tran_id
860: FROM asg_deferred_traninfo);
861: