APPS.PON_UDA_IMPORT_PKG dependencies on DUAL

Line 382: SELECT REGEXP_SUBSTR(l_database_col,'N[^N]+R') INTO l_compare_string FROM dual;

378: AND u.ATTRIBUTE_CATEGORY = l_attr_category
379: AND egoag.attr_group_id = l_attr_group_id
380: AND attr.ATTR_NAME = l_attr_name;
381:
382: SELECT REGEXP_SUBSTR(l_database_col,'N[^N]+R') INTO l_compare_string FROM dual;
383:
384: IF (l_compare_string = 'N_EXT_ATTR' AND l_attr_value_num IS NULL ) THEN
385: l_attr_value_num := 0;
386: END IF;

Line 569: FROM DUAL;

565: d_progress := 110;
566: BEGIN
567: SELECT PO_UDA_INTERFACE_USER_ROW_ID_S.NEXTVAL
568: INTO l_user_row_identifier
569: FROM DUAL;
570: d_progress := 110;
571: PON_UDA_IMPORT_PKG.DEBUG('l_user_row_identifier : ' || l_user_row_identifier, d_progress);
572: EXCEPTION
573: WHEN OTHERS THEN

Line 610: SELECT REGEXP_SUBSTR(l_attr_col_name,'N[^N]+R') INTO l_compare_string FROM dual;

606: d_progress := 210;
607: PON_UDA_IMPORT_PKG.DEBUG('Attribute not found, creating the attribute', d_progress);
608: PON_UDA_IMPORT_PKG.DEBUG('Attr l_attr_col_name : ' || l_attr_col_name, d_progress);
609: IF l_attr_category = 'PRICING' THEN
610: SELECT REGEXP_SUBSTR(l_attr_col_name,'N[^N]+R') INTO l_compare_string FROM dual;
611: PON_UDA_IMPORT_PKG.DEBUG('Attr l_compare_string : ' || l_compare_string, d_progress);
612: IF (l_compare_string = 'N_EXT_ATTR') THEN
613: l_attr_value_num := 0;
614: ELSE

Line 645: SELECT REGEXP_SUBSTR(l_attr_col_name,'N[^N]+R') INTO l_compare_string FROM dual;

641: ELSE
642: d_progress := 250;
643: PON_UDA_IMPORT_PKG.DEBUG('Attr l_attr_col_name 1 : ' || l_attr_col_name, d_progress);
644: IF l_attr_category = 'PRICING' THEN
645: SELECT REGEXP_SUBSTR(l_attr_col_name,'N[^N]+R') INTO l_compare_string FROM dual;
646: PON_UDA_IMPORT_PKG.DEBUG('Attr l_compare_string 1 : ' || l_compare_string, d_progress);
647: IF (l_compare_string = 'N_EXT_ATTR') THEN
648: l_attr_value_num := 0;
649: ELSE

Line 952: FROM DUAL;

948: BEGIN
949: d_progress := 400;
950: SELECT PO_UDA_INTERFACE_ROW_ID_S.NEXTVAL
951: INTO l_row_identifier
952: FROM DUAL;
953:
954: d_progress := 410;
955: PON_UDA_IMPORT_PKG.DEBUG('l_row_identifier : ' || l_row_identifier, d_progress);
956: EXCEPTION

Line 995: FROM DUAL;

991: BEGIN
992: d_progress := 460;
993: SELECT PO_UDA_INTERFACE_USER_ROW_ID_S.NEXTVAL
994: INTO l_user_row_identifier
995: FROM DUAL;
996:
997: d_progress := 470;
998: PON_UDA_IMPORT_PKG.DEBUG('l_user_row_identifier : ' || l_user_row_identifier, d_progress);
999: EXCEPTION

Line 1044: FROM DUAL;

1040: BEGIN
1041: d_progress := 580;
1042: SELECT PO_UDA_INTERFACE_ROW_ID_S.NEXTVAL
1043: INTO l_row_identifier
1044: FROM DUAL;
1045: d_progress := 590;
1046: PON_UDA_IMPORT_PKG.DEBUG('l_row_identifier : ' || l_row_identifier, d_progress);
1047: EXCEPTION
1048: WHEN OTHERS THEN

Line 1087: FROM DUAL;

1083: BEGIN
1084: d_progress := 650;
1085: SELECT PO_UDA_INTERFACE_USER_ROW_ID_S.NEXTVAL
1086: INTO l_user_row_identifier
1087: FROM DUAL;
1088: d_progress := 660;
1089: PON_UDA_IMPORT_PKG.DEBUG('l_user_row_identifier : ' || l_user_row_identifier, d_progress);
1090: EXCEPTION
1091: WHEN OTHERS THEN