eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_AUTO_SYNC_NFN_PKG dependencies on CSM_AUTO_SYNC_NFN

Line 1: PACKAGE BODY CSM_AUTO_SYNC_NFN_PKG AS

1: PACKAGE BODY CSM_AUTO_SYNC_NFN_PKG AS
2: /* $Header: csmuasnb.pls 120.3.12010000.1 2009/08/03 06:32:15 appldev noship $ */
3:
4: /*
5: * The function is to upload csm_auto_sync_nfn auto sync table to base table

Line 5: * The function is to upload csm_auto_sync_nfn auto sync table to base table

1: PACKAGE BODY CSM_AUTO_SYNC_NFN_PKG AS
2: /* $Header: csmuasnb.pls 120.3.12010000.1 2009/08/03 06:32:15 appldev noship $ */
3:
4: /*
5: * The function is to upload csm_auto_sync_nfn auto sync table to base table
6: */
7:
8: --
9: -- MODIFICATION HISTORY

Line 17: g_object_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_NFN_PKG'; -- package name

13: -- --------- ------------------- ------------------------------------------
14: -- Enter procedure, function bodies as shown below
15:
16: /*** Globals ***/
17: g_object_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_NFN_PKG'; -- package name
18: g_pub_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_NFN'; -- publication item name
19: g_debug_level NUMBER; -- debug level
20:
21: g_auto_sync_nfn_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_NFN_ACC';

Line 18: g_pub_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_NFN'; -- publication item name

14: -- Enter procedure, function bodies as shown below
15:
16: /*** Globals ***/
17: g_object_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_NFN_PKG'; -- package name
18: g_pub_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_NFN'; -- publication item name
19: g_debug_level NUMBER; -- debug level
20:
21: g_auto_sync_nfn_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_NFN_ACC';
22: g_auto_sync_nfn_table_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_NFN';

Line 21: g_auto_sync_nfn_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_NFN_ACC';

17: g_object_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_NFN_PKG'; -- package name
18: g_pub_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_NFN'; -- publication item name
19: g_debug_level NUMBER; -- debug level
20:
21: g_auto_sync_nfn_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_NFN_ACC';
22: g_auto_sync_nfn_table_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_NFN';
23: g_auto_sync_nfn_seq_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_NFN_ACC_S';
24: g_auto_sync_nfn_pk1_name CONSTANT VARCHAR2(30) := 'NOTIFICATION_ID';
25: g_auto_sync_nfn_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=

Line 22: g_auto_sync_nfn_table_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_NFN';

18: g_pub_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_NFN'; -- publication item name
19: g_debug_level NUMBER; -- debug level
20:
21: g_auto_sync_nfn_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_NFN_ACC';
22: g_auto_sync_nfn_table_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_NFN';
23: g_auto_sync_nfn_seq_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_NFN_ACC_S';
24: g_auto_sync_nfn_pk1_name CONSTANT VARCHAR2(30) := 'NOTIFICATION_ID';
25: g_auto_sync_nfn_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
26: CSM_ACC_PKG.t_publication_item_list('CSM_AUTO_SYNC_NFN');

Line 23: g_auto_sync_nfn_seq_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_NFN_ACC_S';

19: g_debug_level NUMBER; -- debug level
20:
21: g_auto_sync_nfn_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_NFN_ACC';
22: g_auto_sync_nfn_table_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_NFN';
23: g_auto_sync_nfn_seq_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_NFN_ACC_S';
24: g_auto_sync_nfn_pk1_name CONSTANT VARCHAR2(30) := 'NOTIFICATION_ID';
25: g_auto_sync_nfn_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
26: CSM_ACC_PKG.t_publication_item_list('CSM_AUTO_SYNC_NFN');
27:

Line 26: CSM_ACC_PKG.t_publication_item_list('CSM_AUTO_SYNC_NFN');

22: g_auto_sync_nfn_table_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_NFN';
23: g_auto_sync_nfn_seq_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_NFN_ACC_S';
24: g_auto_sync_nfn_pk1_name CONSTANT VARCHAR2(30) := 'NOTIFICATION_ID';
25: g_auto_sync_nfn_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
26: CSM_ACC_PKG.t_publication_item_list('CSM_AUTO_SYNC_NFN');
27:
28:
29: CURSOR c_auto_sync_nfn_inq( b_user_name VARCHAR2, b_tranid NUMBER) IS
30: SELECT *

Line 31: FROM csm_auto_sync_nfn_inq

27:
28:
29: CURSOR c_auto_sync_nfn_inq( b_user_name VARCHAR2, b_tranid NUMBER) IS
30: SELECT *
31: FROM csm_auto_sync_nfn_inq
32: WHERE tranid$$ = b_tranid
33: AND clid$$cs = b_user_name;
34: -----------------------------------------------------------------------------------------------------------
35:

Line 68: FROM CSM_AUTO_SYNC_NFN

64:
65: -- get all notifications in which user is a recipient
66: CURSOR c_notf(b_user_id fnd_user.user_id%TYPE) IS
67: SELECT DISTINCT notification_id
68: FROM CSM_AUTO_SYNC_NFN
69: WHERE user_id=b_user_id;
70:
71: BEGIN
72: CSM_UTIL_PKG.LOG('Entering AUTO_SYNC_NFN_ACC_PROCESSOR for user_id: ' || p_user_id,

Line 88: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_AUTO_SYNC_NFN_PKG.AUTO_SYNC_NFN_ACC_PROCESSOR',FND_LOG.LEVEL_EXCEPTION);

84: l_sqlerrno := to_char(SQLCODE);
85: l_sqlerrmsg := substr(SQLERRM, 1,2000);
86: l_error_msg := ' Exception in AUTO_SYNC_NFN_ACC_PROCESSOR for for user_id: ' || p_user_id
87: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
88: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_AUTO_SYNC_NFN_PKG.AUTO_SYNC_NFN_ACC_PROCESSOR',FND_LOG.LEVEL_EXCEPTION);
89: RAISE;
90:
91: END AUTO_SYNC_NFN_ACC_PROCESSOR;
92:

Line 108: l_notification_id csm_auto_sync_nfn.notification_id%TYPE ;

104: x_reject_row OUT NOCOPY BOOLEAN
105: ) IS
106:
107:
108: l_notification_id csm_auto_sync_nfn.notification_id%TYPE ;
109: l_object_id csm_auto_sync_nfn.object_id%TYPE;
110: l_object_name csm_auto_sync_nfn.object_name%TYPE;
111: l_user_id csm_auto_sync_nfn.user_id%TYPE;
112: l_user_name asg_user.user_name%TYPE;

Line 109: l_object_id csm_auto_sync_nfn.object_id%TYPE;

105: ) IS
106:
107:
108: l_notification_id csm_auto_sync_nfn.notification_id%TYPE ;
109: l_object_id csm_auto_sync_nfn.object_id%TYPE;
110: l_object_name csm_auto_sync_nfn.object_name%TYPE;
111: l_user_id csm_auto_sync_nfn.user_id%TYPE;
112: l_user_name asg_user.user_name%TYPE;
113:

Line 110: l_object_name csm_auto_sync_nfn.object_name%TYPE;

106:
107:
108: l_notification_id csm_auto_sync_nfn.notification_id%TYPE ;
109: l_object_id csm_auto_sync_nfn.object_id%TYPE;
110: l_object_name csm_auto_sync_nfn.object_name%TYPE;
111: l_user_id csm_auto_sync_nfn.user_id%TYPE;
112: l_user_name asg_user.user_name%TYPE;
113:
114: l_rowid ROWID;

Line 111: l_user_id csm_auto_sync_nfn.user_id%TYPE;

107:
108: l_notification_id csm_auto_sync_nfn.notification_id%TYPE ;
109: l_object_id csm_auto_sync_nfn.object_id%TYPE;
110: l_object_name csm_auto_sync_nfn.object_name%TYPE;
111: l_user_id csm_auto_sync_nfn.user_id%TYPE;
112: l_user_name asg_user.user_name%TYPE;
113:
114: l_rowid ROWID;
115:

Line 119: FROM CSM_AUTO_SYNC_NFN

115:
116: CURSOR c_record_exists
117: (b_notification_id NUMBER
118: )IS SELECT ROWID
119: FROM CSM_AUTO_SYNC_NFN
120: WHERE notification_id = b_notification_id;
121:
122: BEGIN
123:

Line 126: 'CSM_AUTO_SYNC_NFN.APPLY_INSERT',

122: BEGIN
123:
124: CSM_UTIL_PKG.log( 'Entering ' || g_object_name || '.APPLY_INSERT:'
125: || ' for PK ' || p_record.notification_id,
126: 'CSM_AUTO_SYNC_NFN.APPLY_INSERT',
127: FND_LOG.LEVEL_PROCEDURE );
128:
129: /***************************************************************************
130: ** Initialize API return status to success

Line 139: insert into csm_auto_sync_nfn(USER_ID,

135: l_object_id := p_record.object_id;
136: l_object_name := p_record.object_name;
137: l_user_id := p_record.user_id;
138:
139: insert into csm_auto_sync_nfn(USER_ID,
140: NOTIFICATION_ID,
141: OBJECT_ID ,
142: OBJECT_NAME,
143: COMMAND_ID ,

Line 225: FROM csm_auto_sync_nfn

221: )
222: IS
223: CURSOR c_auto_sync_nfn ( b_notification_id NUMBER ) IS
224: SELECT *
225: FROM csm_auto_sync_nfn
226: WHERE notification_id = b_notification_id;
227:
228: CURSOR c_last_update_date ( b_notification_id NUMBER)
229: IS

Line 232: FROM csm_auto_sync_nfn

228: CURSOR c_last_update_date ( b_notification_id NUMBER)
229: IS
230: SELECT LAST_UPDATE_DATE,
231: last_updated_by
232: FROM csm_auto_sync_nfn
233: WHERE notification_id = b_notification_id;
234:
235:
236: --variable declarations

Line 240: l_notification_id csm_auto_sync_nfn.notification_id%TYPE ;

236: --variable declarations
237:
238: l_item_rec c_auto_sync_nfn%ROWTYPE;
239:
240: l_notification_id csm_auto_sync_nfn.notification_id%TYPE ;
241: l_object_id csm_auto_sync_nfn.object_id%TYPE;
242: l_object_name csm_auto_sync_nfn.object_name%TYPE;
243: l_user_id csm_auto_sync_nfn.user_id%TYPE;
244: l_user_name asg_user.user_name%TYPE;

Line 241: l_object_id csm_auto_sync_nfn.object_id%TYPE;

237:
238: l_item_rec c_auto_sync_nfn%ROWTYPE;
239:
240: l_notification_id csm_auto_sync_nfn.notification_id%TYPE ;
241: l_object_id csm_auto_sync_nfn.object_id%TYPE;
242: l_object_name csm_auto_sync_nfn.object_name%TYPE;
243: l_user_id csm_auto_sync_nfn.user_id%TYPE;
244: l_user_name asg_user.user_name%TYPE;
245:

Line 242: l_object_name csm_auto_sync_nfn.object_name%TYPE;

238: l_item_rec c_auto_sync_nfn%ROWTYPE;
239:
240: l_notification_id csm_auto_sync_nfn.notification_id%TYPE ;
241: l_object_id csm_auto_sync_nfn.object_id%TYPE;
242: l_object_name csm_auto_sync_nfn.object_name%TYPE;
243: l_user_id csm_auto_sync_nfn.user_id%TYPE;
244: l_user_name asg_user.user_name%TYPE;
245:
246: l_rowid ROWID;

Line 243: l_user_id csm_auto_sync_nfn.user_id%TYPE;

239:
240: l_notification_id csm_auto_sync_nfn.notification_id%TYPE ;
241: l_object_id csm_auto_sync_nfn.object_id%TYPE;
242: l_object_name csm_auto_sync_nfn.object_name%TYPE;
243: l_user_id csm_auto_sync_nfn.user_id%TYPE;
244: l_user_name asg_user.user_name%TYPE;
245:
246: l_rowid ROWID;
247:

Line 253: 'CSM_AUTO_SYNC_NFN.APPLY_UPDATE',

249:
250:
251: CSM_UTIL_PKG.log( 'Entering ' || g_object_name || '.APPLY_UPDATE:'
252: || ' for PK ' || p_record.notification_id,
253: 'CSM_AUTO_SYNC_NFN.APPLY_UPDATE',
254: FND_LOG.LEVEL_PROCEDURE );
255: /***************************************************************************
256: ** Initialize API return status to success
257: ***************************************************************************/

Line 276: fnd_message.set_name ('CSM', 'CSM_AUTO_SYNC_NFN');

272: IF (c_auto_sync_nfn%ISOPEN) THEN
273: CLOSE c_auto_sync_nfn;
274: END IF;
275:
276: fnd_message.set_name ('CSM', 'CSM_AUTO_SYNC_NFN');
277: fnd_message.set_token ('NOTIFICATION_ID', p_record.notification_id);
278: fnd_msg_pub.add;
279: RAISE no_data_found;
280: END IF;

Line 290: UPDATE csm_auto_sync_nfn

286: /***************************************************************************
287: ** Update the record
288: ***************************************************************************/
289:
290: UPDATE csm_auto_sync_nfn
291: SET USER_ID = l_user_id,
292: NOTIFICATION_ID = p_record.notification_id,
293: OBJECT_ID = p_record.object_id ,
294: OBJECT_NAME = p_record.object_name,

Line 318: -- delete csm_auto_sync_nfn_inq where clid$$cs = l_user_name and notification_id = l_notification_id;

314: RAISE NO_DATA_FOUND;
315: END IF;
316:
317: -- success
318: -- delete csm_auto_sync_nfn_inq where clid$$cs = l_user_name and notification_id = l_notification_id;
319: x_return_status := FND_API.G_RET_STS_SUCCESS;
320:
321: EXCEPTION
322:

Line 417: publication item CSM_AUTO_SYNC_NFN

413: ----------------------------------------------------------------------------------------------------------------------
414:
415: /***
416: APPLY_CLIENT_CHANGE procedure is called by CSM_SERVICEP_WRAPPER_PKG, for upward sync of
417: publication item CSM_AUTO_SYNC_NFN
418: ***/
419: PROCEDURE APPLY_CLIENT_CHANGES
420: (
421: p_user_name IN VARCHAR2,

Line 557: END CSM_AUTO_SYNC_NFN_PKG;

553:
554: END APPLY_CLIENT_CHANGES;
555:
556:
557: END CSM_AUTO_SYNC_NFN_PKG;