APPS.GMA_PURGE_COPY dependencies on STANDARD

Line 66: -- No literals to change to bind variables as per coding standard,

62:
63: -- create and open cursor for detail table rowids
64: -- Made by Khaja
65:
66: -- No literals to change to bind variables as per coding standard,
67: -- because none of the variables are entered by user.
68:
69: l_sqlstatement := 'SELECT UNIQUE rowidtochar(' ||
70: l_sourcetable ||

Line 118: -- Changing literals to bind variables as per coding standard.

114: END IF;
115: DBMS_SQL.COLUMN_VALUE(l_detailcursor,1,l_detailrowid);
116:
117: -- do copy
118: -- Changing literals to bind variables as per coding standard.
119: l_sqlstatement := 'INSERT INTO '|| p_owner || '.' || l_arctablename --Bug#6681753
120: || ' SELECT * FROM ' ||
121: l_sourcetable || ' WHERE ROWID = :b_detailrowid ';
122: -- l_sourcetable || ' WHERE ROWID = ' || '''' ||

Line 132: -- Changing literals to bind variables as per coding standard.

128:
129: l_return := DBMS_SQL.EXECUTE(g_copycursor);
130:
131: -- do delete
132: -- Changing literals to bind variables as per coding standard.
133: l_sqlstatement := 'DELETE FROM ' ||l_sourcetable ||
134: ' WHERE ROWID = :b_detailrowid ';
135: DBMS_SQL.PARSE(g_copycursor,l_sqlstatement,DBMS_SQL.NATIVE);
136:

Line 162: -- Changing literals to bind variables as per coding standard.

158: END IF;
159: DBMS_SQL.COLUMN_VALUE(l_detailcursor,1,l_detailrowid);
160:
161: -- do copy
162: -- Changing literals to bind variables as per coding standard.
163: l_sqlstatement := 'INSERT INTO ' || p_owner || '.' || l_arctablename || --Bug#6681753
164: ' SELECT * FROM ' ||
165: l_sourcetable || ' WHERE ROWID =:b_detailrowid ';
166: DBMS_SQL.PARSE(g_copycursor,l_sqlstatement,DBMS_SQL.NATIVE);