DBA Data[Home] [Help]

APPS.CSL_SERVICEL_WRAPPER_PKG dependencies on ASG_APPLY

Line 15: p_pubitems_tbl IN OUT NOCOPY asg_apply.vc2_tbl_type,

11: When the item name was found, it will be removed from the list.
12: ***/
13: FUNCTION ITEM_EXISTS
14: (
15: p_pubitems_tbl IN OUT NOCOPY asg_apply.vc2_tbl_type,
16: p_item_name IN VARCHAR2
17: )
18: RETURN BOOLEAN IS
19: l_index BINARY_INTEGER;

Line 84: This procedure is called by ASG_APPLY.APPLY_CLIENT_CHANGES if a list of dirty publication items

80: RETURN FALSE;
81: END ITEM_EXISTS;
82:
83: /***
84: This procedure is called by ASG_APPLY.APPLY_CLIENT_CHANGES if a list of dirty publication items
85: has been retrieved for a user/tranid combination. This procedure gets called for both
86: deferred and non-deferred publication items.
87: ***/
88: PROCEDURE APPLY_DIRTY_PUBITEMS

Line 92: p_pubitems_tbl IN OUT NOCOPY asg_apply.vc2_tbl_type,

88: PROCEDURE APPLY_DIRTY_PUBITEMS
89: (
90: p_user_name IN VARCHAR2,
91: p_tranid IN NUMBER,
92: p_pubitems_tbl IN OUT NOCOPY asg_apply.vc2_tbl_type,
93: x_return_status IN OUT NOCOPY VARCHAR2
94: ) IS
95: l_index BINARY_INTEGER;
96: BEGIN

Line 383: This procedure is called by ASG_APPLY.PROCESS_UPLOAD when a publication item for publication SERVICEL

379: x_return_status := FND_API.G_RET_STS_ERROR;
380: END APPLY_DIRTY_PUBITEMS;
381:
382: /***
383: This procedure is called by ASG_APPLY.PROCESS_UPLOAD when a publication item for publication SERVICEL
384: is dirty. This happens when a mobile field service device executed DML on an updatable table and did
385: a fast sync. This procedure will detect which publication items got dirty and will execute the wrapper
386: procedures which will insert the data that came from mobile into the backend tables using public APIs.
387: ***/

Line 393: l_pubitems_tbl asg_apply.vc2_tbl_type;

389: (
390: p_user_name IN VARCHAR2,
391: p_tranid IN NUMBER
392: ) IS
393: l_pubitems_tbl asg_apply.vc2_tbl_type;
394: l_return_status VARCHAR2(1);
395: BEGIN
396: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
397:

Line 417: asg_apply.get_all_pub_items(p_user_name,

413: END IF;
414:
415: /*** retrieve names of non-deferred dirty SERVICEL publication items ***/
416: /*** get_all_dirty and get_all_defered_pub_items is replaced by get_all_pub_items ***/
417: asg_apply.get_all_pub_items(p_user_name,
418: p_tranid,
419: 'SERVICEL',
420: l_pubitems_tbl,
421: l_return_status);

Line 430: , v_message => 'asg_apply.get_all_dirty_pub_items didn''t return any records'

426: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
427: jtm_message_log_pkg.Log_Msg
428: ( v_object_id => null
429: , v_object_name => g_object_name
430: , v_message => 'asg_apply.get_all_dirty_pub_items didn''t return any records'
431: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
432: END IF;
433: ELSE
434: /*** yes -> process them ***/

Line 452: /* asg_apply.get_all_deferred_pub_items(p_user_name,

448: );
449: END IF;
450:
451: /*** retrieve names of deferred dirty SERVICEL publication items ***/
452: /* asg_apply.get_all_deferred_pub_items(p_user_name,
453: p_tranid,
454: 'SERVICEL',
455: l_pubitems_tbl,
456: l_return_status);

Line 466: , v_message => 'asg_apply.get_all_deferred_pub_items didn''t return any records'

462: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
463: jtm_message_log_pkg.Log_Msg
464: ( v_object_id => null
465: , v_object_name => g_object_name
466: , v_message => 'asg_apply.get_all_deferred_pub_items didn''t return any records'
467: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
468: END IF;
469: ELSE
470: /*** yes -> process them ***/

Line 654: asg_apply.delete_row(p_user_name,

650: , v_message => 'Entering ' || g_object_name || '.DELETE_RECORD'
651: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
652: END IF;
653:
654: asg_apply.delete_row(p_user_name,
655: p_tranid,
656: p_pub_name,
657: p_seqno,
658: x_return_status);