APPS.CSM_HTML5_PKG dependencies on ASG_APPLY

Line 2895: l_pubitems_tbl asg_apply.vc2_tbl_type;

2891: l_resource_id NUMBER;
2892: l_select_store_sqlstring VARCHAR2(512);
2893: l_select_inqcnt_sqlstring VARCHAR2(512);
2894: l_delete_inq_sqlstring VARCHAR2(512);
2895: l_pubitems_tbl asg_apply.vc2_tbl_type;
2896: curr_tranid NUMBER;
2897: curr_pubitem VARCHAR2(30);
2898: curr_pubitem_length PLS_INTEGER;
2899: l_pubitems_max_length PLS_INTEGER := 4000;

Line 3044: p_pubitems_tbl IN asg_apply.vc2_tbl_type,

3040: -- Procedure to purge all the dirty INQ records for
3041: -- the specified user/transid/publication-item(s)
3042: PROCEDURE purge_pubitems(p_user_name IN VARCHAR2,
3043: p_tranid IN NUMBER,
3044: p_pubitems_tbl IN asg_apply.vc2_tbl_type,
3045: x_return_status OUT NOCOPY VARCHAR2)
3046: IS
3047: num_pubitems PLS_INTEGER;
3048: counter PLS_INTEGER;

Line 3179: l_pubitems_tbl asg_apply.vc2_tbl_type;

3175: PROCEDURE purge_pubitems(p_user_name IN VARCHAR2,
3176: p_tranid IN NUMBER,
3177: x_return_status OUT NOCOPY VARCHAR2)
3178: IS
3179: l_pubitems_tbl asg_apply.vc2_tbl_type;
3180: CURSOR l_c IS SELECT PI_NAME FROM CSM_HTML5_INQ WHERE USER_NAME=p_user_name AND SYNC_ID=p_tranid;
3181: BEGIN
3182:
3183: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR

Line 3221: l_tranid_tbl asg_apply.num_tbl_type;

3217: IS
3218:
3219: counter PLS_INTEGER;
3220: curr_tranid NUMBER;
3221: l_tranid_tbl asg_apply.num_tbl_type;
3222: cursor c_tranids (p_user_name VARCHAR2, p_max_tranid NUMBER) IS
3223: SELECT tranid FROM asg_users_inqinfo
3224: WHERE device_user_name = p_user_name AND
3225: tranid <= p_max_tranid;

Line 3415: --x_return_status := FND_API.G_RET_STS_ERROR; --in asg_apply returns as SUCCESS always

3411: EXCEPTION
3412: WHEN OTHERS THEN
3413: CSM_UTIL_PKG.LOG( 'Exception occurred in process_user:'||SUBSTR(SQLERRM,1,3000), 'CSM_HTML5_PKG.process_user',FND_LOG.LEVEL_EXCEPTION);
3414: fnd_global.apps_initialize(l_conc_userid, l_conc_respid, l_conc_appid);
3415: --x_return_status := FND_API.G_RET_STS_ERROR; --in asg_apply returns as SUCCESS always
3416: END;
3417: END process_user;
3418:
3419: PROCEDURE process_upload(curr_user IN VARCHAR2)

Line 3451: x_pubitems_tbl OUT NOCOPY asg_apply.vc2_tbl_type,

3447:
3448:
3449: PROCEDURE get_all_pub_items(p_user_name IN VARCHAR2,
3450: p_tranid IN NUMBER,
3451: x_pubitems_tbl OUT NOCOPY asg_apply.vc2_tbl_type,
3452: x_return_status OUT NOCOPY VARCHAR2)
3453: IS
3454: counter PLS_INTEGER;
3455: CURSOR l_cursor1 IS

Line 3494: asg_apply.sort_by_weight('SERVICEP', x_pubitems_tbl);

3490:
3491: IF(l_n=x_pubitems_tbl.COUNT) THEN l_dummy:=false; END IF;
3492:
3493: IF l_dummy THEN
3494: asg_apply.sort_by_weight('SERVICEP', x_pubitems_tbl);
3495: END IF;
3496:
3497: END get_all_pub_items;
3498: