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_PKG dependencies on CSM_AUTO_SYNC

Line 1: PACKAGE BODY CSM_AUTO_SYNC_PKG AS

1: PACKAGE BODY CSM_AUTO_SYNC_PKG AS
2: /* $Header: csmuasb.pls 120.6 2009/08/06 06:32:45 hbeeram noship $ */
3:
4: /*
5: * The function is to upload csm_auto_sync table to base table

Line 5: * The function is to upload csm_auto_sync table to base table

1: PACKAGE BODY CSM_AUTO_SYNC_PKG AS
2: /* $Header: csmuasb.pls 120.6 2009/08/06 06:32:45 hbeeram noship $ */
3:
4: /*
5: * The function is to upload csm_auto_sync table to base table
6: */
7:
8: --
9: -- MODIFICATION HISTORY

Line 17: g_object_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_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_PKG'; -- package name
18: g_pub_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC'; -- publication item name
19: g_debug_level NUMBER; -- debug level
20:
21: g_auto_sync_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_ACC';

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

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

Line 21: g_auto_sync_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_ACC';

17: g_object_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_PKG'; -- package name
18: g_pub_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC'; -- publication item name
19: g_debug_level NUMBER; -- debug level
20:
21: g_auto_sync_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_ACC';
22: g_auto_sync_table_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC';
23: g_auto_sync_seq_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_ACC_S';
24: g_auto_sync_pk1_name CONSTANT VARCHAR2(30) := 'ID';
25: g_auto_sync_pk2_name CONSTANT VARCHAR2(30) := 'AUTO_SYNC_NUM';

Line 22: g_auto_sync_table_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC';

18: g_pub_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC'; -- publication item name
19: g_debug_level NUMBER; -- debug level
20:
21: g_auto_sync_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_ACC';
22: g_auto_sync_table_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC';
23: g_auto_sync_seq_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_ACC_S';
24: g_auto_sync_pk1_name CONSTANT VARCHAR2(30) := 'ID';
25: g_auto_sync_pk2_name CONSTANT VARCHAR2(30) := 'AUTO_SYNC_NUM';
26: g_auto_sync_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=

Line 23: g_auto_sync_seq_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_ACC_S';

19: g_debug_level NUMBER; -- debug level
20:
21: g_auto_sync_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_ACC';
22: g_auto_sync_table_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC';
23: g_auto_sync_seq_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_ACC_S';
24: g_auto_sync_pk1_name CONSTANT VARCHAR2(30) := 'ID';
25: g_auto_sync_pk2_name CONSTANT VARCHAR2(30) := 'AUTO_SYNC_NUM';
26: g_auto_sync_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
27: CSM_ACC_PKG.t_publication_item_list('CSM_AUTO_SYNC');

Line 27: CSM_ACC_PKG.t_publication_item_list('CSM_AUTO_SYNC');

23: g_auto_sync_seq_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_ACC_S';
24: g_auto_sync_pk1_name CONSTANT VARCHAR2(30) := 'ID';
25: g_auto_sync_pk2_name CONSTANT VARCHAR2(30) := 'AUTO_SYNC_NUM';
26: g_auto_sync_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
27: CSM_ACC_PKG.t_publication_item_list('CSM_AUTO_SYNC');
28:
29:
30: CURSOR c_auto_sync_inq( b_user_name VARCHAR2, b_tranid NUMBER) IS
31: SELECT *

Line 32: FROM csm_auto_sync_inq

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

Line 70: FROM csm_auto_sync;

66:
67: -- get all notifications in which user is a recipient
68: CURSOR c_id(b_user_id fnd_user.user_id%TYPE) IS
69: SELECT id, auto_sync_num
70: FROM csm_auto_sync;
71:
72: BEGIN
73: CSM_UTIL_PKG.LOG('Entering AUTO_SYNC_ACC_PROCESSOR for user_id: ' || p_user_id,
74: g_object_name || '.AUTO_SYNC_ACC_PROCESSOR',FND_LOG.LEVEL_PROCEDURE);

Line 92: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_AUTO_SYNC_PKG.AUTO_SYNC_ACC_PROCESSOR',FND_LOG.LEVEL_EXCEPTION);

88: l_sqlerrno := to_char(SQLCODE);
89: l_sqlerrmsg := substr(SQLERRM, 1,2000);
90: l_error_msg := ' Exception in AUTO_SYNC_ACC_PROCESSOR for for user_id: ' || p_user_id
91: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
92: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_AUTO_SYNC_PKG.AUTO_SYNC_ACC_PROCESSOR',FND_LOG.LEVEL_EXCEPTION);
93: RAISE;
94:
95: END AUTO_SYNC_ACC_PROCESSOR;
96: /******************************************************************************************************************/

Line 113: l_id csm_auto_sync.id%TYPE ;

109: x_reject_row OUT NOCOPY BOOLEAN
110: ) IS
111:
112:
113: l_id csm_auto_sync.id%TYPE ;
114: l_flag csm_auto_sync.flag%TYPE;
115: l_rowid ROWID;
116:
117: CURSOR c_record_exists

Line 114: l_flag csm_auto_sync.flag%TYPE;

110: ) IS
111:
112:
113: l_id csm_auto_sync.id%TYPE ;
114: l_flag csm_auto_sync.flag%TYPE;
115: l_rowid ROWID;
116:
117: CURSOR c_record_exists
118: (b_id NUMBER

Line 120: FROM CSM_AUTO_SYNC

116:
117: CURSOR c_record_exists
118: (b_id NUMBER
119: )IS SELECT ROWID
120: FROM CSM_AUTO_SYNC
121: WHERE id = b_id;
122:
123:
124:

Line 130: 'CSM_AUTO_SYNC.APPLY_INSERT',

126:
127:
128: CSM_UTIL_PKG.log( 'Entering ' || g_object_name || '.APPLY_INSERT:'
129: || ' for PK ' || p_record.id,
130: 'CSM_AUTO_SYNC.APPLY_INSERT',
131: FND_LOG.LEVEL_PROCEDURE );
132:
133: /***************************************************************************
134: ** Initialize API return status to success

Line 139: insert into csm_auto_sync(ID,FLAG,AUTO_SYNC_NUM,DOWNLOAD_ONLY,CREATION_DATE ,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY)

135: ***************************************************************************/
136: x_return_status := FND_API.G_RET_STS_SUCCESS;
137:
138: /*
139: insert into csm_auto_sync(ID,FLAG,AUTO_SYNC_NUM,DOWNLOAD_ONLY,CREATION_DATE ,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY)
140: values (p_record.id,p_record.flag,p_record.auto_sync_num,p_record.download_only,p_record.creation_date ,p_record.created_by,p_record.last_update_date,p_record.last_updated_by)
141: RETURNING ID INTO l_id;
142: */
143: /***************************************************************************

Line 207: l_id csm_auto_sync.id%TYPE ;

203: )
204: IS
205: --variable declarations
206:
207: l_id csm_auto_sync.id%TYPE ;
208: l_auto_sync_num csm_auto_sync.auto_sync_num%TYPE;
209: l_user_id asg_user.user_id%TYPE;
210:
211: l_rowid ROWID;

Line 208: l_auto_sync_num csm_auto_sync.auto_sync_num%TYPE;

204: IS
205: --variable declarations
206:
207: l_id csm_auto_sync.id%TYPE ;
208: l_auto_sync_num csm_auto_sync.auto_sync_num%TYPE;
209: l_user_id asg_user.user_id%TYPE;
210:
211: l_rowid ROWID;
212:

Line 218: 'CSM_AUTO_SYNC.APPLY_UPDATE',

214:
215:
216: CSM_UTIL_PKG.log( 'Entering ' || g_object_name || '.APPLY_UPDATE:'
217: || ' for PK ' || p_record.id,
218: 'CSM_AUTO_SYNC.APPLY_UPDATE',
219: FND_LOG.LEVEL_PROCEDURE );
220: /***************************************************************************
221: ** Initialize API return status to success
222: ***************************************************************************/

Line 233: UPDATE csm_auto_sync_acc

229: /***************************************************************************
230: ** Update the record
231: ***************************************************************************/
232:
233: UPDATE csm_auto_sync_acc
234: SET AUTO_SYNC_NUM = l_auto_sync_num,
235: LAST_UPDATE_DATE = sysdate,
236: LAST_UPDATED_BY = l_user_id
237: where ID=l_id

Line 348: publication item CSM_AUTO_SYNC

344: ----------------------------------------------------------------------------------------------------------------------
345:
346: /***
347: APPLY_CLIENT_CHANGE procedure is called by CSM_SERVICEP_WRAPPER_PKG, for upward sync of
348: publication item CSM_AUTO_SYNC
349: ***/
350: PROCEDURE APPLY_CLIENT_CHANGES
351: (
352: p_user_name IN VARCHAR2,

Line 471: END CSM_AUTO_SYNC_PKG;

467:
468: END APPLY_CLIENT_CHANGES;
469:
470:
471: END CSM_AUTO_SYNC_PKG;