DBA Data[Home] [Help]

APPS.ASO_ATP_INT dependencies on DUAL

Line 34: DBMS_SQL.PARSE(cursor_c1, 'Select MRP_ATP_SCHEDULE_TEMP_S.NextVal@' || p_dblink ||' From Dual', dbms_sql.native);

30: cursor_name := dbms_sql.open_cursor;
31: DBMS_SQL.PARSE(cursor_name, 'alter session close database link ' ||p_dblink, dbms_sql.native);
32:
33: cursor_c1 := dbms_sql.open_cursor;
34: DBMS_SQL.PARSE(cursor_c1, 'Select MRP_ATP_SCHEDULE_TEMP_S.NextVal@' || p_dblink ||' From Dual', dbms_sql.native);
35:
36: BEGIN
37: dbms_sql.define_column( cursor_c1, 1, l_session_id );
38: rows_1 := dbms_sql.execute(cursor_c1);

Line 2076: From Dual;

2072:
2073:
2074: Select MRP_ATP_SCHEDULE_TEMP_S.NextVal
2075: Into l_session_id
2076: From Dual;
2077:
2078: /* Get profile value for ASO: ATP Use Sourcing Rules. If the value is null or 'N
2079: ' then get l_ship_from_org_id from the profile ASO_SHIP_FROM_ORG_ID and pass the
2080: source_organization_id as the value of l_ship_from_org_id else get Default Custo