APPS.POS_EXCELASN_PVT dependencies on DUAL

Line 3148: select RCV_TRANSACTIONS_INTERFACE_S.nextval into l_intf_txn_id from dual;

3144: is
3145: l_intf_txn_id number;
3146: begin
3147: insert into pos_exasn_lines(line_id, quantity, license_plate_number) values(p_line_id, p_qty, p_lpn );
3148: select RCV_TRANSACTIONS_INTERFACE_S.nextval into l_intf_txn_id from dual;
3149: update pos_exasn_lines
3150: set (
3151: PRIMARY_UOM,
3152: LPN_GROUP_ID,

Line 3357: select rcv_interface_groups_s.nextval into l_lpn_group_id from dual;

3353: IS
3354: l_lpn_group_id number;
3355: l_header_interface_id number;
3356: BEGIN
3357: select rcv_interface_groups_s.nextval into l_lpn_group_id from dual;
3358: select rcv_headers_interface_s.nextval into l_header_interface_id from dual;
3359:
3360: insert into pos_exasn_headers(
3361: header_id,

Line 3358: select rcv_headers_interface_s.nextval into l_header_interface_id from dual;

3354: l_lpn_group_id number;
3355: l_header_interface_id number;
3356: BEGIN
3357: select rcv_interface_groups_s.nextval into l_lpn_group_id from dual;
3358: select rcv_headers_interface_s.nextval into l_header_interface_id from dual;
3359:
3360: insert into pos_exasn_headers(
3361: header_id,
3362: lpn_group_id,

Line 4242: SELECT FND_GLOBAL.USER_NAME INTO l_user_name FROM DUAL;

4238: x_error_tbl := POS_EXCELASN_ERROR_TABLE();
4239:
4240: --x_user_vendor_id will no longer be retrieved from the secured attribute,
4241: --ICX_SUPPLIER_ORG_ID
4242: SELECT FND_GLOBAL.USER_NAME INTO l_user_name FROM DUAL;
4243: x_user_vendor_id :=POS_VENDOR_UTIL_PKG.GET_PO_VENDOR_ID_FOR_USER(l_user_name);
4244:
4245: -- Check Securing Attributes
4246: