APPS.CSM_NOTIFICATION_EVENT_PKG dependencies on CSM_DEFERRED_NFN_INFO

Line 1770: from csm_deferred_nfn_info nfn , asg_pub_item pi, asg_user usr, wf_roles wfrl

1766: CURSOR c_get_deferred_data(b_id NUMBER)
1767: IS
1768: select nfn.deferred_tran_id,nfn.sequence, nfn.client_id, DECODE(NVL(usr.multi_platform,'N'),'Y','WEBKIT-Based',NVL(usr.cookie,'WINCE')) as DEVICE_TYPE,
1769: wfrl.display_name, nfn.object_name, pi.primary_key_column, nfn.object_id, nfn.error_msg,nfn.creation_date
1770: from csm_deferred_nfn_info nfn , asg_pub_item pi, asg_user usr, wf_roles wfrl
1771: where tracking_id=b_id
1772: and wfrl.name=nfn.client_id
1773: and nfn.object_name=pi.item_id
1774: and usr.user_name=nfn.client_id;

Line 1987: FROM CSM_DEFERRED_NFN_INFO

1983: BEGIN
1984:
1985: BEGIN
1986: SELECT tracking_id INTO l_tracking_id
1987: FROM CSM_DEFERRED_NFN_INFO
1988: WHERE CLIENT_ID=p_user_name
1989: AND DEFERRED_TRAN_ID=p_tranid
1990: AND DML=p_dml_type
1991: AND SEQUENCE=p_sequence;

Line 2024: l_sql:= 'SELECT TRACKING_ID FROM CSM_DEFERRED_NFN_INFO WHERE OBJECT_NAME='''||l_parent_pi ||''''

2020: FETCH c_parent INTO l_parent_pi;
2021: EXIT WHEN c_parent%NOTFOUND;
2022: /* IF l_parent_pi IS NOT NULL THEN*/
2023: BEGIN
2024: l_sql:= 'SELECT TRACKING_ID FROM CSM_DEFERRED_NFN_INFO WHERE OBJECT_NAME='''||l_parent_pi ||''''
2025: ||' AND OBJECT_ID=(SELECT '||get_source_object_column(l_parent_pi,p_pubitem)|| ' FROM '
2026: ||p_pubitem||'_INQ WHERE '||l_pk_clause||' '||get_source_object_code_str(l_parent_pi,p_pubitem) ||') '
2027: ||' AND DEFERRED_TRAN_ID ='||p_tranid ||' AND CLIENT_ID='''||p_user_name||'''';
2028:

Line 2042: select CSM_DEFERRED_NFN_INFO_S.nextval into l_tracking_id from dual;

2038: END LOOP;
2039:
2040: CLOSE c_parent;
2041:
2042: select CSM_DEFERRED_NFN_INFO_S.nextval into l_tracking_id from dual;
2043:
2044:
2045: IF isRoot AND NOT CSM_UTIL_PKG.IS_HTML5_USER(p_user_name) THEN --notify/email user
2046: --Check if auto sync is enabled

Line 2123: INSERT INTO CSM_DEFERRED_NFN_INFO(TRACKING_ID,CLIENT_ID,NOTIFICATION_ID,OBJECT_NAME , OBJECT_ID,

2119:
2120:
2121: --insert into tracking table
2122:
2123: INSERT INTO CSM_DEFERRED_NFN_INFO(TRACKING_ID,CLIENT_ID,NOTIFICATION_ID,OBJECT_NAME , OBJECT_ID,
2124: DEFERRED_TRAN_ID , SEQUENCE, DML , PARENT_ID , ERROR_MSG ,CREATION_DATE )
2125: VALUES(l_tracking_id,p_user_name,l_notification_id,p_pubitem,p_pk,p_tranid,p_sequence,
2126: p_dml_type,l_parent_tracking_id,p_error_msg,sysdate);
2127:

Line 2162: delete from csm_deferred_nfn_info where client_id=csm_util_pkg.get_user_name(p_user_id);

2158: delete from csm_auto_sync_nfn_acc where user_id=p_user_id;
2159:
2160: delete from csm_deferred_transactions_acc where user_id=p_user_id;
2161:
2162: delete from csm_deferred_nfn_info where client_id=csm_util_pkg.get_user_name(p_user_id);
2163:
2164: for rec in (select nfn.notification_id from csm_auto_sync_nfn nfn, wf_notifications wfn
2165: where nfn.user_id=p_user_id and nfn.notification_id = wfn.notification_id
2166: and wfn.status='OPEN')