DBA Data[Home] [Help]

APPS.AMW_LOAD_AP_DATA dependencies on AMW_AUDIT_PROCEDURES_PVT

Line 200: l_ap_rec AMW_AUDIT_PROCEDURES_PVT.audit_procedure_rec_type;

196: l_api_version_number CONSTANT NUMBER := 1.0;
197: l_requestor_id NUMBER;
198: l_amw_delt_ap_intf VARCHAR2 (2);
199: l_amw_ap_name_prefix VARCHAR2 (30);
200: l_ap_rec AMW_AUDIT_PROCEDURES_PVT.audit_procedure_rec_type;
201: l_ap_found BOOLEAN default true;
202: l_step_found BOOLEAN default true;
203: l_process_steps BOOLEAN default false;
204: l_ap_approval_status_code VARCHAR2(30);

Line 384: AMW_AUDIT_PROCEDURES_PVT.Load_Ap(

380: ---03.01.2005 npanandi: added data security checks ends
381:
382: ---03.01.2005 npanandi: call for LoadAP reqd. only if this has l_has_access='T'
383: if(l_has_access = 'T') then
384: AMW_AUDIT_PROCEDURES_PVT.Load_Ap(
385: p_api_version_number => l_api_version_number,
386: p_init_msg_list => FND_API.G_TRUE,
387: p_commit => FND_API.G_FALSE,
388: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 444: AMW_AUDIT_PROCEDURES_PVT.INSERT_AP_STEP(

440: AND LATEST_REVISION_FLAG='Y';
441:
442: ---03.01.2005 npanandi: call for LoadAP reqd. only if this has l_has_access='T'
443: if(l_has_access = 'T') then
444: AMW_AUDIT_PROCEDURES_PVT.INSERT_AP_STEP(
445: P_API_VERSION_NUMBER => L_API_VERSION_NUMBER,
446: P_INIT_MSG_LIST => FND_API.G_TRUE,
447: P_COMMIT => FND_API.G_FALSE,
448: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

Line 498: AMW_AUDIT_PROCEDURES_PVT.INSERT_AP_CONTROL_ASSOC(

494: fnd_file.put_line(fnd_file.LOG,'L_AUDIT_PROCEDURE_ID: '||L_AUDIT_PROCEDURE_ID||', L_AUDIT_PROCEDURE_REV_ID: '||L_AUDIT_PROCEDURE_REV_ID);
495:
496: ---03.01.2005 npanandi: call for LoadAP reqd. only if this has l_has_access='T'
497: if(l_has_access = 'T') then
498: AMW_AUDIT_PROCEDURES_PVT.INSERT_AP_CONTROL_ASSOC(
499: P_API_VERSION_NUMBER => L_API_VERSION_NUMBER,
500: P_INIT_MSG_LIST => FND_API.G_TRUE,
501: P_COMMIT => FND_API.G_FALSE,
502: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,