APPS.ASG_CONS_QPKG dependencies on ASG_PURGE_SDQ

Line 28: -- 19-feb-2003 pkanukol Support for processing asg_purge_sdq at synch time

24: -- 25-mar-2003 ssabesan update synch_errors column with synch time errors
25: -- 25-feb-2003 rsripada Added validate_login method
26: -- 24-feb-2003 rsripada update hwm_tranid so that it can handle
27: -- exceptions in download
28: -- 19-feb-2003 pkanukol Support for processing asg_purge_sdq at synch time
29: -- 11-feb-2003 rsripada Support for conflict detection
30: -- 10-feb-2003 rsripada change asg_disable_custom
31: -- to asg_disable_custom_synch
32: -- 06-jan-2003 ssabesan Added NOCOPY in function definition

Line 1082: --procedure for processing asg_purge_sdq at synch time

1078:
1079: END get_conf_pub_items_list;
1080:
1081:
1082: --procedure for processing asg_purge_sdq at synch time
1083: PROCEDURE process_purge_Sdq ( p_clientid IN VARCHAR2,
1084: p_last_tranid IN NUMBER,
1085: p_curr_tranid IN NUMBER)
1086: IS

Line 1089: FROM asg_purge_sdq

1085: p_curr_tranid IN NUMBER)
1086: IS
1087: CURSOR c_purgeSdq(c_username varchar2,c_pub_name varchar2) is
1088: SELECT NVL(transaction_id,-100)
1089: FROM asg_purge_sdq
1090: WHERE user_name = c_username AND pub_name = c_pub_name;
1091: l_tran_id NUMBER;
1092: l_dml VARCHAR2(255);
1093: l_qry_string varchar2(4000);

Line 1130: UPDATE asg_purge_sdq

1126: ' ( select item_id from asg_pub_item where '||
1127: ' pub_name = :1 )';
1128: EXECUTE IMMEDIATE l_qry_string1
1129: USING l_pub_name;
1130: UPDATE asg_purge_sdq
1131: SET transaction_id=p_curr_tranid,last_update_date=sysdate
1132: WHERE user_name=p_clientid AND pub_name = l_pub_name;
1133: ELSIF ( p_last_tranid < l_tran_id )
1134: THEN

Line 1144: UPDATE asg_purge_sdq

1140: ' ( select item_id from asg_pub_item where '||
1141: ' pub_name = :1 )';
1142: EXECUTE IMMEDIATE l_qry_string1
1143: USING l_pub_name;
1144: UPDATE asg_purge_sdq
1145: SET transaction_id=p_curr_tranid,last_update_date=sysdate
1146: WHERE user_name=p_clientid AND pub_name = l_pub_name;
1147: ELSE
1148: --previous synch succeded ..so delete from purge_sdq

Line 1149: asg_helper.log('Deleting asg_purge_sdq for user '||p_clientid||' and '||

1145: SET transaction_id=p_curr_tranid,last_update_date=sysdate
1146: WHERE user_name=p_clientid AND pub_name = l_pub_name;
1147: ELSE
1148: --previous synch succeded ..so delete from purge_sdq
1149: asg_helper.log('Deleting asg_purge_sdq for user '||p_clientid||' and '||
1150: ' publication '||l_pub_name,'asg_cons_qpkg',g_stmt_level);
1151: DELETE FROM asg_purge_sdq
1152: WHERE user_name = p_clientid AND pub_name = l_pub_name;
1153: END IF;

Line 1151: DELETE FROM asg_purge_sdq

1147: ELSE
1148: --previous synch succeded ..so delete from purge_sdq
1149: asg_helper.log('Deleting asg_purge_sdq for user '||p_clientid||' and '||
1150: ' publication '||l_pub_name,'asg_cons_qpkg',g_stmt_level);
1151: DELETE FROM asg_purge_sdq
1152: WHERE user_name = p_clientid AND pub_name = l_pub_name;
1153: END IF;
1154: ELSE
1155: null;

Line 1427: FROM asg_purge_sdq

1423: FROM asg_user
1424: WHERE user_name = p_user_name AND
1425: hwm_tranid IS NULL AND
1426: NOT EXISTS (SELECT 1
1427: FROM asg_purge_sdq
1428: WHERE user_name = p_user_name and
1429: transaction_id is NOT null);
1430: COMMIT;
1431: return l_first_synch;