DBA Data[Home] [Help]

APPS.AP_APXVDDUP_XMLP_PKG dependencies on AP_VENDOR_AUDIT_TMP

Line 85: DELETE FROM ap_vendor_audit_tmp;

81: /*SRW.USER_EXIT('FND SRWINIT');*/null;
82: IF (p_debug_switch = 'Y') THEN
83: /*SRW.MESSAGE('1','After SRWINIT');*/null;
84: END IF;
85: DELETE FROM ap_vendor_audit_tmp;
86: COMMIT;
87: IF (get_company_name() <> TRUE) THEN RAISE init_failure;
88: END IF;
89: IF (p_debug_switch = 'Y') THEN

Line 205: INSERT INTO ap_vendor_audit_tmp

201: c_first_match_vendor_id := l_vendor_id;
202: ELSE
203: IF C_OLD_NAME = l_SUBSTR_NEW_NAME AND
204: C_first_match_flag = 'Y' THEN
205: INSERT INTO ap_vendor_audit_tmp
206: (vendor_id,
207: vendor_number,
208: vendor_name)
209: VALUES (c_first_match_vendor_id,

Line 213: INSERT INTO ap_vendor_audit_tmp

209: VALUES (c_first_match_vendor_id,
210: c_first_match_vendor_number,
211: c_first_match_vendor_name);
212: COMMIT;
213: INSERT INTO ap_vendor_audit_tmp
214: (vendor_id,
215: vendor_number,
216: vendor_name)
217: VALUES (l_vendor_id,

Line 224: INSERT INTO ap_vendor_audit_tmp

220: COMMIT;
221: C_first_match_flag := 'N';
222: ELSE
223: IF C_OLD_NAME = l_SUBSTR_NEW_NAME THEN
224: INSERT INTO ap_vendor_audit_tmp
225: (vendor_id,
226: vendor_number,
227: vendor_name)
228: VALUES (l_vendor_id,