APPS.CSM_SERVICEP_WRAPPER_PKG dependencies on ASG_APPLY

Line 19: x_pubitems_tbl OUT NOCOPY asg_apply.vc2_tbl_type,

15:
16: PROCEDURE GET_ALL_DEFERRED_PUB_ITEMS(p_username IN VARCHAR2,
17: p_tranid IN NUMBER,
18: p_pubname IN VARCHAR2,
19: x_pubitems_tbl OUT NOCOPY asg_apply.vc2_tbl_type,
20: x_return_status OUT NOCOPY VARCHAR2)
21: IS
22: l_defer_count pls_integer;
23: l_all_pubitems_tbl asg_apply.vc2_tbl_type;

Line 23: l_all_pubitems_tbl asg_apply.vc2_tbl_type;

19: x_pubitems_tbl OUT NOCOPY asg_apply.vc2_tbl_type,
20: x_return_status OUT NOCOPY VARCHAR2)
21: IS
22: l_defer_count pls_integer;
23: l_all_pubitems_tbl asg_apply.vc2_tbl_type;
24: l_null_pubitems_tbl asg_apply.vc2_tbl_type;
25: l_return_status varchar2(1);
26: l_dummy number;
27:

Line 24: l_null_pubitems_tbl asg_apply.vc2_tbl_type;

20: x_return_status OUT NOCOPY VARCHAR2)
21: IS
22: l_defer_count pls_integer;
23: l_all_pubitems_tbl asg_apply.vc2_tbl_type;
24: l_null_pubitems_tbl asg_apply.vc2_tbl_type;
25: l_return_status varchar2(1);
26: l_dummy number;
27:
28: CURSOR c_isdeferred(p_user_name VARCHAR2, p_tran_id NUMBER, p_pubitem VARCHAR2)

Line 45: asg_apply.get_all_pub_items(p_username,

41: l_all_pubitems_tbl := l_null_pubitems_tbl;
42: x_pubitems_tbl := l_null_pubitems_tbl;
43:
44: /*** retrieve names of deferred dirty SERVICEP publication items ***/
45: asg_apply.get_all_pub_items(p_username,
46: p_tranid,
47: 'SERVICEP',
48: l_all_pubitems_tbl,
49: l_return_status);

Line 79: p_pubitems_tbl IN OUT nocopy asg_apply.vc2_tbl_type,

75: When the item name was found, it will be removed from the list.
76: ***/
77: FUNCTION ITEM_EXISTS
78: (
79: p_pubitems_tbl IN OUT nocopy asg_apply.vc2_tbl_type,
80: p_item_name IN VARCHAR2
81: )
82: RETURN BOOLEAN IS
83: l_index BINARY_INTEGER;

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

108: RETURN FALSE;
109: END ITEM_EXISTS;
110:
111: /***
112: This procedure is called by ASG_APPLY.APPLY_CLIENT_CHANGES if a list of dirty publication items
113: has been retrieved for a user/tranid combination. This procedure gets called for both
114: deferred and non-deferred publication items.
115: ***/
116: PROCEDURE APPLY_DIRTY_PUBITEMS

Line 120: p_pubitems_tbl IN OUT nocopy asg_apply.vc2_tbl_type,

116: PROCEDURE APPLY_DIRTY_PUBITEMS
117: (
118: p_user_name IN VARCHAR2,
119: p_tranid IN NUMBER,
120: p_pubitems_tbl IN OUT nocopy asg_apply.vc2_tbl_type,
121: x_return_status IN OUT nocopy VARCHAR2
122: ) IS
123: l_index BINARY_INTEGER;
124: BEGIN

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

311:
312: END APPLY_DIRTY_PUBITEMS;
313:
314: /***
315: This procedure is called by ASG_APPLY.PROCESS_UPLOAD when a publication item for publication SERVICEL
316: is dirty. This happens when a mobile field service device executed DML on an updatable table and did
317: a fast sync. This procedure will detect which publication items got dirty and will execute the wrapper
318: procedures which will insert the data that came from mobile into the backend tables using public APIs.
319: ***/

Line 325: l_pubitems_tbl asg_apply.vc2_tbl_type;

321: (
322: p_user_name IN VARCHAR2,
323: p_tranid IN NUMBER
324: ) IS
325: l_pubitems_tbl asg_apply.vc2_tbl_type;
326: l_return_status VARCHAR2(1);
327: BEGIN
328:
329: /*** retrieve names of all dirty SERVICEP publication items ***/

Line 331: asg_apply.get_all_pub_items(p_user_name,

327: BEGIN
328:
329: /*** retrieve names of all dirty SERVICEP publication items ***/
330: /*** get_all_dirty and get_all_defered_pub_items is replaced by get_all_pub_items ***/
331: asg_apply.get_all_pub_items(p_user_name,
332: p_tranid,
333: 'SERVICEP',
334: l_pubitems_tbl,
335: l_return_status);