497: d_progress := 110;
498: BEGIN
499: SELECT PO_UDA_INTERFACE_USER_ROW_ID_S.NEXTVAL
500: INTO l_user_row_identifier
501: FROM DUAL;
502: d_progress := 110;
503: PO_UDA_DEFAULTING_PKG.DEBUG('l_user_row_identifier : ' || l_user_row_identifier, d_progress);
504: EXCEPTION
505: WHEN OTHERS THEN
870: BEGIN
871: d_progress := 400;
872: SELECT PO_UDA_INTERFACE_ROW_ID_S.NEXTVAL
873: INTO l_row_identifier
874: FROM DUAL;
875:
876: d_progress := 410;
877: PO_UDA_DEFAULTING_PKG.DEBUG('l_row_identifier : ' || l_row_identifier, d_progress);
878: EXCEPTION
913: BEGIN
914: d_progress := 460;
915: SELECT PO_UDA_INTERFACE_USER_ROW_ID_S.NEXTVAL
916: INTO l_user_row_identifier
917: FROM DUAL;
918:
919: d_progress := 470;
920: PO_UDA_DEFAULTING_PKG.DEBUG('l_user_row_identifier : ' || l_user_row_identifier, d_progress);
921: EXCEPTION
962: BEGIN
963: d_progress := 580;
964: SELECT PO_UDA_INTERFACE_ROW_ID_S.NEXTVAL
965: INTO l_row_identifier
966: FROM DUAL;
967: d_progress := 590;
968: PO_UDA_DEFAULTING_PKG.DEBUG('l_row_identifier : ' || l_row_identifier, d_progress);
969: EXCEPTION
970: WHEN OTHERS THEN
1005: BEGIN
1006: d_progress := 650;
1007: SELECT PO_UDA_INTERFACE_USER_ROW_ID_S.NEXTVAL
1008: INTO l_user_row_identifier
1009: FROM DUAL;
1010: d_progress := 660;
1011: PO_UDA_DEFAULTING_PKG.DEBUG('l_user_row_identifier : ' || l_user_row_identifier, d_progress);
1012: EXCEPTION
1013: WHEN OTHERS THEN
2466: --If the record exists, then the record needs to be updated
2467: --If record doesnt exist, then insert a new record in po_lines_all_ext_b
2468: SELECT 'Y'
2469: INTO l_records_exist
2470: FROM dual
2471: WHERE EXISTS ( SELECT 1
2472: FROM
2473: po_lines_all_ext_b
2474: WHERE draft_id = l_draft_id_tbl(i)
3389: LOOP
3390:
3391: SELECT 'N'
3392: INTO l_is_valid
3393: FROM dual
3394: WHERE EXISTS ( SELECT attr_name
3395: FROM ego_attrs_v
3396: WHERE ATTR_GROUP_TYPE = l_attr_group_typ_tbl(j)
3397: AND ATTR_GROUP_NAME = l_attr_grp_name_tbl(k)