APPS.ASG_CONS_QPKG dependencies on ASG_PURGE_SDQ

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

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

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

1037:
1038: END get_conf_pub_items_list;
1039:
1040:
1041: --procedure for processing asg_purge_sdq at synch time
1042: PROCEDURE process_purge_Sdq ( p_clientid IN VARCHAR2,
1043: p_last_tranid IN NUMBER,
1044: p_curr_tranid IN NUMBER)
1045: IS

Line 1048: FROM asg_purge_sdq

1044: p_curr_tranid IN NUMBER)
1045: IS
1046: CURSOR c_purgeSdq(c_username varchar2,c_pub_name varchar2) is
1047: SELECT NVL(transaction_id,-100)
1048: FROM asg_purge_sdq
1049: WHERE user_name = c_username AND pub_name = c_pub_name;
1050: l_tran_id NUMBER;
1051: l_dml VARCHAR2(255);
1052: l_qry_string varchar2(4000);

Line 1089: UPDATE asg_purge_sdq

1085: ' ( select item_id from asg_pub_item where '||
1086: ' pub_name = :1 )';
1087: EXECUTE IMMEDIATE l_qry_string1
1088: USING l_pub_name;
1089: UPDATE asg_purge_sdq
1090: SET transaction_id=p_curr_tranid,last_update_date=sysdate
1091: WHERE user_name=p_clientid AND pub_name = l_pub_name;
1092: ELSIF ( p_last_tranid < l_tran_id )
1093: THEN

Line 1103: UPDATE asg_purge_sdq

1099: ' ( select item_id from asg_pub_item where '||
1100: ' pub_name = :1 )';
1101: EXECUTE IMMEDIATE l_qry_string1
1102: USING l_pub_name;
1103: UPDATE asg_purge_sdq
1104: SET transaction_id=p_curr_tranid,last_update_date=sysdate
1105: WHERE user_name=p_clientid AND pub_name = l_pub_name;
1106: ELSE
1107: --previous synch succeded ..so delete from purge_sdq

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

1104: SET transaction_id=p_curr_tranid,last_update_date=sysdate
1105: WHERE user_name=p_clientid AND pub_name = l_pub_name;
1106: ELSE
1107: --previous synch succeded ..so delete from purge_sdq
1108: asg_helper.log('Deleting asg_purge_sdq for user '||p_clientid||' and '||
1109: ' publication '||l_pub_name,'asg_cons_qpkg',g_stmt_level);
1110: DELETE FROM asg_purge_sdq
1111: WHERE user_name = p_clientid AND pub_name = l_pub_name;
1112: END IF;

Line 1110: DELETE FROM asg_purge_sdq

1106: ELSE
1107: --previous synch succeded ..so delete from purge_sdq
1108: asg_helper.log('Deleting asg_purge_sdq for user '||p_clientid||' and '||
1109: ' publication '||l_pub_name,'asg_cons_qpkg',g_stmt_level);
1110: DELETE FROM asg_purge_sdq
1111: WHERE user_name = p_clientid AND pub_name = l_pub_name;
1112: END IF;
1113: ELSE
1114: null;

Line 1386: FROM asg_purge_sdq

1382: FROM asg_user
1383: WHERE user_name = p_user_name AND
1384: hwm_tranid IS NULL AND
1385: NOT EXISTS (SELECT 1
1386: FROM asg_purge_sdq
1387: WHERE user_name = p_user_name and
1388: transaction_id is NOT null);
1389: COMMIT;
1390: return l_first_synch;