DBA Data[Home] [Help]

APPS.GML_GPOAO dependencies on DUAL

Line 122: FROM sys.dual;

118: xProgress := 'GPOAO-10-1010';
119: BEGIN
120: SELECT ece_output_runs_s.NEXTVAL
121: INTO v_RunID
122: FROM sys.dual;
123: EXCEPTION
124: WHEN NO_DATA_FOUND THEN
125: ec_debug.pl ( 0,
126: 'EC',

Line 503: dual

499: lpad(p_Order_No_From, v_format_size, v_pad_char)
500: INTO
501: v_Order_No_From
502: FROM
503: dual
504: ;
505: End If;
506: If ( p_Order_No_To is NOT NULL ) Then
507: v_Order_No_To := lpad(p_Order_No_To, v_format_size, v_pad_char);

Line 514: dual

510: lpad(p_Order_No_To, v_format_size, v_pad_char)
511: INTO
512: v_Order_No_To
513: FROM
514: dual
515: ;
516: End If;
517: End If;
518:

Line 1068: FROM sys.dual;

1064:
1065: xProgress := 'GPOAOB-10-1810';
1066: SELECT GML_GPOAO_ORDERS_S.nextval
1067: INTO v_ORD_Key
1068: FROM sys.dual;
1069:
1070: xProgress := 'GPOAOB-10-1820';
1071: ece_extract_utils_pub.insert_into_interface_tbl ( p_RunID,
1072: p_TransactionType,

Line 1305: FROM sys.dual;

1301:
1302: xProgress := 'GPOAOB-10-2070';
1303: SELECT GML_GPOAO_DETAILS_S.nextval
1304: INTO v_DTL_Key
1305: FROM sys.dual;
1306: ec_debug.pl( 3, 'V_DTL_Key:', v_DTL_Key);
1307:
1308: xProgress := 'GPOAOB-10-2080';
1309: ece_extract_utils_pub.insert_into_interface_tbl ( p_RunID,