APPS.POS_EXCELASN_PVT dependencies on DUAL

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

3074: is
3075: l_intf_txn_id number;
3076: begin
3077: insert into pos_exasn_lines(line_id, quantity, license_plate_number) values(p_line_id, p_qty, p_lpn );
3078: select RCV_TRANSACTIONS_INTERFACE_S.nextval into l_intf_txn_id from dual;
3079: update pos_exasn_lines
3080: set (
3081: PRIMARY_UOM,
3082: LPN_GROUP_ID,

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

3283: IS
3284: l_lpn_group_id number;
3285: l_header_interface_id number;
3286: BEGIN
3287: select rcv_interface_groups_s.nextval into l_lpn_group_id from dual;
3288: select rcv_headers_interface_s.nextval into l_header_interface_id from dual;
3289:
3290: insert into pos_exasn_headers(
3291: header_id,

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

3284: l_lpn_group_id number;
3285: l_header_interface_id number;
3286: BEGIN
3287: select rcv_interface_groups_s.nextval into l_lpn_group_id from dual;
3288: select rcv_headers_interface_s.nextval into l_header_interface_id from dual;
3289:
3290: insert into pos_exasn_headers(
3291: header_id,
3292: lpn_group_id,

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

4164: x_error_tbl := POS_EXCELASN_ERROR_TABLE();
4165:
4166: --x_user_vendor_id will no longer be retrieved from the secured attribute,
4167: --ICX_SUPPLIER_ORG_ID
4168: SELECT FND_GLOBAL.USER_NAME INTO l_user_name FROM DUAL;
4169: x_user_vendor_id :=POS_VENDOR_UTIL_PKG.GET_PO_VENDOR_ID_FOR_USER(l_user_name);
4170:
4171: -- Check Securing Attributes
4172: