APPS.PO_DIFF_CONFIG_PKG dependencies on PO_DIFF_CONFIG

Line 1: PACKAGE BODY PO_DIFF_CONFIG_PKG AS

1: PACKAGE BODY PO_DIFF_CONFIG_PKG AS
2: /* $Header: PO_DIFF_CONFIG_PKG.plb 120.0 2011/10/13 18:12:15 bhuchand noship $ */
3:
4: PROCEDURE INSERT_ROW (
5: P_DIFF_CONFIG_ID IN NUMBER,

Line 2: /* $Header: PO_DIFF_CONFIG_PKG.plb 120.0 2011/10/13 18:12:15 bhuchand noship $ */

1: PACKAGE BODY PO_DIFF_CONFIG_PKG AS
2: /* $Header: PO_DIFF_CONFIG_PKG.plb 120.0 2011/10/13 18:12:15 bhuchand noship $ */
3:
4: PROCEDURE INSERT_ROW (
5: P_DIFF_CONFIG_ID IN NUMBER,
6: P_DOCUMENT_TYPE IN VARCHAR2,

Line 27: insert into PO_DIFF_CONFIG(

23: P_LAST_UPDATE_LOGIN IN NUMBER
24: ) is
25: begin
26:
27: insert into PO_DIFF_CONFIG(
28: DIFF_CONFIG_ID,
29: DOCUMENT_TYPE,
30: ENTITY_NAME,
31: SUB_ENTITY_NAME,

Line 93: update PO_DIFF_CONFIG set

89: P_LAST_UPDATED_BY IN NUMBER,
90: P_LAST_UPDATE_LOGIN IN NUMBER
91: ) is
92: begin
93: update PO_DIFF_CONFIG set
94: DOCUMENT_TYPE = P_DOCUMENT_TYPE,
95: ENTITY_NAME = P_ENTITY_NAME,
96: SUB_ENTITY_NAME = P_SUB_ENTITY_NAME,
97: BASE_DOC_SOURCE_NAME = P_BASE_DOC_SOURCE_NAME,

Line 137: update PO_DIFF_CONFIG set

133: P_LAST_UPDATED_BY IN NUMBER,
134: P_LAST_UPDATE_LOGIN IN NUMBER
135: ) is
136: begin
137: update PO_DIFF_CONFIG set
138: DOCUMENT_TYPE = P_DOCUMENT_TYPE,
139: ENTITY_NAME = P_ENTITY_NAME,
140: SUB_ENTITY_NAME = P_SUB_ENTITY_NAME,
141: BASE_DOC_SOURCE_NAME = P_BASE_DOC_SOURCE_NAME,

Line 199: FROM PO_DIFF_CONFIG

195: SELECT LAST_UPDATED_BY,
196: LAST_UPDATE_DATE
197: INTO DB_LUBY,
198: DB_LUDATE
199: FROM PO_DIFF_CONFIG
200: WHERE DIFF_CONFIG_ID = L_DIFF_CONFIG_ID
201: and DIFF_CONFIG_ID < 10000;
202:
203: IF (FND_LOAD_UTIL.UPLOAD_TEST(P_FILE_ID => F_LUBY,

Line 210: PO_DIFF_CONFIG_PKG.FORCE_UPDATE_ROW(

206: P_DB_LUD => DB_LUDATE,
207: P_CUSTOM_MODE => L_CUSTOM_MODE)) THEN
208: if L_CUSTOM_MODE = 'FORCE' then
209: /* this will update all columns including ignore_source_flag */
210: PO_DIFF_CONFIG_PKG.FORCE_UPDATE_ROW(
211: P_DIFF_CONFIG_ID => L_DIFF_CONFIG_ID,
212: P_DOCUMENT_TYPE => L_DOCUMENT_TYPE,
213: P_ENTITY_NAME => L_ENTITY_NAME,
214: P_SUB_ENTITY_NAME => L_SUB_ENTITY_NAME,

Line 231: PO_DIFF_CONFIG_PKG.UPDATE_ROW(

227: P_LAST_UPDATE_LOGIN => 0
228: );
229: else
230: /* UPDATE If the the record found with the above criteria */
231: PO_DIFF_CONFIG_PKG.UPDATE_ROW(
232: P_DIFF_CONFIG_ID => L_DIFF_CONFIG_ID,
233: P_DOCUMENT_TYPE => L_DOCUMENT_TYPE,
234: P_ENTITY_NAME => L_ENTITY_NAME,
235: P_SUB_ENTITY_NAME => L_SUB_ENTITY_NAME,

Line 255: PO_DIFF_CONFIG_PKG.INSERT_ROW (

251: END IF;
252: EXCEPTION
253: WHEN No_Data_Found THEN
254: /* If data does not exist, insert the new record */
255: PO_DIFF_CONFIG_PKG.INSERT_ROW (
256: P_DIFF_CONFIG_ID => L_DIFF_CONFIG_ID,
257: P_DOCUMENT_TYPE => L_DOCUMENT_TYPE,
258: P_ENTITY_NAME => L_ENTITY_NAME,
259: P_SUB_ENTITY_NAME => L_SUB_ENTITY_NAME,

Line 284: END PO_DIFF_CONFIG_PKG;

280: fnd_file.put_line(fnd_file.log,
281: 'Row cannot be updated - ' || 'DIFF_CONFIG_ID = ' || L_DIFF_CONFIG_ID);
282: END LOAD_ROW;
283:
284: END PO_DIFF_CONFIG_PKG;