DBA Data[Home] [Help]

APPS.POS_WCAPPROVE_PVT dependencies on DUAL

Line 112: from sys.dual;

108: If (p_itemkey is NULL) then
109:
110: select to_char(PO_WF_ITEMKEY_S.NEXTVAL)
111: into l_seq_for_item_key
112: from sys.dual;
113:
114: l_itemkey := to_char(p_work_confirmation_id) || '-' ||
115: l_seq_for_item_key;
116: else

Line 4033: FROM SYS.DUAL;

4029:
4030:
4031: SELECT rcv_headers_interface_s.NEXTVAL
4032: INTO l_header_interface_id
4033: FROM SYS.DUAL;
4034:
4035: select rcv_interface_groups_s.nextval
4036: into l_group_id
4037: from dual;

Line 4037: from dual;

4033: FROM SYS.DUAL;
4034:
4035: select rcv_interface_groups_s.nextval
4036: into l_group_id
4037: from dual;
4038:
4039: IF (g_asn_debug = 'Y') THEN
4040: debug_log(FND_LOG.LEVEL_STATEMENT,
4041: l_api_name,'l_header_interface_id ' ||

Line 4443: from dual;

4439:
4440: If (l_insert_into_rti) then --{
4441: select rcv_transactions_interface_s.nextval
4442: into l_interface_id
4443: from dual;
4444:
4445: IF (g_asn_debug = 'Y') THEN
4446: debug_log(FND_LOG.LEVEL_STATEMENT,
4447: l_api_name,'l_interface_id ' || l_interface_id);