APPS.ASG_DEFER dependencies on ASG_APPLY

Line 141: l_cp_run := asg_apply.is_conc_program_running;

137: l_error_msg := p_error_msg;
138: END IF;
139: select nvl(fnd_profile.value_specific('ASG_ENABLE_UPLOAD_EVENTS'),'N')
140: into l_prof_value from dual;
141: l_cp_run := asg_apply.is_conc_program_running;
142:
143: if(l_prof_value = 'Y')
144: then
145: if(l_cp_run = 'N' )

Line 443: asg_apply.delete_row(p_user_name, p_tranid, p_pubitem, p_sequence,

439: -- Check if this transaction is deferred
440: l_def_trans := is_deferred(p_user_name, p_tranid, p_pubitem, p_sequence);
441: IF l_def_trans = FND_API.G_FALSE THEN
442: -- Delete the row from inq
443: asg_apply.delete_row(p_user_name, p_tranid, p_pubitem, p_sequence,
444: x_return_status);
445: END IF;
446: IF(asg_helper.check_is_log_enabled(g_stmt_level))
447: THEN

Line 605: l_pubitems_tbl asg_apply.vc2_tbl_type;

601: counter PLS_INTEGER;
602: sql_string VARCHAR2(4000);
603: l_pub_handler asg_pub.wrapper_name%type;
604: l_pubname VARCHAR2(30);
605: l_pubitems_tbl asg_apply.vc2_tbl_type;
606: l_def_trans VARCHAR2(1);
607: l_return_status VARCHAR2(1);
608: l_pubs_tbl asg_apply.vc2_tbl_type;
609: l_pubhandlers_tbl asg_apply.vc2_tbl_type;

Line 608: l_pubs_tbl asg_apply.vc2_tbl_type;

604: l_pubname VARCHAR2(30);
605: l_pubitems_tbl asg_apply.vc2_tbl_type;
606: l_def_trans VARCHAR2(1);
607: l_return_status VARCHAR2(1);
608: l_pubs_tbl asg_apply.vc2_tbl_type;
609: l_pubhandlers_tbl asg_apply.vc2_tbl_type;
610: l_def_count NUMBER;
611: l_user_id NUMBER;
612: l_resp_id NUMBER;

Line 609: l_pubhandlers_tbl asg_apply.vc2_tbl_type;

605: l_pubitems_tbl asg_apply.vc2_tbl_type;
606: l_def_trans VARCHAR2(1);
607: l_return_status VARCHAR2(1);
608: l_pubs_tbl asg_apply.vc2_tbl_type;
609: l_pubhandlers_tbl asg_apply.vc2_tbl_type;
610: l_def_count NUMBER;
611: l_user_id NUMBER;
612: l_resp_id NUMBER;
613: l_app_id NUMBER;

Line 667: l_pubitems_tbl := asg_apply.g_empty_vc2_tbl;

663: ' current pub : ' || l_pubname ||
664: ' current pub handler: ' || l_pub_handler,
665: 'asg_defer',g_stmt_level);
666: END IF;
667: l_pubitems_tbl := asg_apply.g_empty_vc2_tbl;
668: asg_apply.get_all_pub_items(p_user_name, p_tranid, l_pubname,
669: l_pubitems_tbl, l_return_status);
670: -- Check if there is any data for this publication
671: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) AND

Line 668: asg_apply.get_all_pub_items(p_user_name, p_tranid, l_pubname,

664: ' current pub handler: ' || l_pub_handler,
665: 'asg_defer',g_stmt_level);
666: END IF;
667: l_pubitems_tbl := asg_apply.g_empty_vc2_tbl;
668: asg_apply.get_all_pub_items(p_user_name, p_tranid, l_pubname,
669: l_pubitems_tbl, l_return_status);
670: -- Check if there is any data for this publication
671: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) AND
672: (l_pubitems_tbl.count >0) THEN

Line 749: l_pubitems_tbl asg_apply.vc2_tbl_type;

745: x_return_status OUT NOCOPY VARCHAR2)
746: IS
747: l_def_trans VARCHAR2(1);
748: l_curr_pubitem VARCHAR2(30);
749: l_pubitems_tbl asg_apply.vc2_tbl_type;
750: l_return_status VARCHAR2(1);
751: BEGIN
752: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
753: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN

Line 771: asg_apply.get_all_pub_items(p_user_name, p_tranid,

767: ' transaction: ' || p_tranid,
768: 'asg_defer',g_stmt_level);
769: END IF;
770: x_return_status := FND_API.G_RET_STS_SUCCESS;
771: asg_apply.get_all_pub_items(p_user_name, p_tranid,
772: l_pubitems_tbl, l_return_status);
773: -- Check if there is any data for this publication
774: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) AND
775: (l_pubitems_tbl.count >0) THEN