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 3834: FROM SYS.DUAL;

3830:
3831:
3832: SELECT rcv_headers_interface_s.NEXTVAL
3833: INTO l_header_interface_id
3834: FROM SYS.DUAL;
3835:
3836: select rcv_interface_groups_s.nextval
3837: into l_group_id
3838: from dual;

Line 3838: from dual;

3834: FROM SYS.DUAL;
3835:
3836: select rcv_interface_groups_s.nextval
3837: into l_group_id
3838: from dual;
3839:
3840: IF (g_asn_debug = 'Y') THEN
3841: debug_log(FND_LOG.LEVEL_STATEMENT,
3842: l_api_name,'l_header_interface_id ' ||

Line 4216: from dual;

4212:
4213: If (l_insert_into_rti) then --{
4214: select rcv_transactions_interface_s.nextval
4215: into l_interface_id
4216: from dual;
4217:
4218: IF (g_asn_debug = 'Y') THEN
4219: debug_log(FND_LOG.LEVEL_STATEMENT,
4220: l_api_name,'l_interface_id ' || l_interface_id);