368: l_ar_schema VARCHAR2(255);
369: l_bool BOOLEAN;
370: BEGIN
371:
372: l_apps_schema := hz_utility_v2pub.Get_AppsSchemaName;
373: l_ar_schema := hz_utility_v2pub.Get_SchemaName('AR');
374:
375: IF G_SETUP_LOADED = 'Y' THEN
376: RETURN;
369: l_bool BOOLEAN;
370: BEGIN
371:
372: l_apps_schema := hz_utility_v2pub.Get_AppsSchemaName;
373: l_ar_schema := hz_utility_v2pub.Get_SchemaName('AR');
374:
375: IF G_SETUP_LOADED = 'Y' THEN
376: RETURN;
377: END IF;
1012:
1013: l_procedure_name := 'reset_who';
1014:
1015: l('PROCEDURE '||l_procedure_name || ' (');
1016: li('p_request_id NUMBER := hz_utility_v2pub.request_id, ');
1017: li('p_program_id NUMBER := hz_utility_v2pub.program_id, ');
1018: li('p_program_application_id NUMBER := hz_utility_v2pub.program_application_id ');
1019: l(') IS');
1020: l('BEGIN');
1013: l_procedure_name := 'reset_who';
1014:
1015: l('PROCEDURE '||l_procedure_name || ' (');
1016: li('p_request_id NUMBER := hz_utility_v2pub.request_id, ');
1017: li('p_program_id NUMBER := hz_utility_v2pub.program_id, ');
1018: li('p_program_application_id NUMBER := hz_utility_v2pub.program_application_id ');
1019: l(') IS');
1020: l('BEGIN');
1021: li('g_created_by := hz_utility_v2pub.created_by;');
1014:
1015: l('PROCEDURE '||l_procedure_name || ' (');
1016: li('p_request_id NUMBER := hz_utility_v2pub.request_id, ');
1017: li('p_program_id NUMBER := hz_utility_v2pub.program_id, ');
1018: li('p_program_application_id NUMBER := hz_utility_v2pub.program_application_id ');
1019: l(') IS');
1020: l('BEGIN');
1021: li('g_created_by := hz_utility_v2pub.created_by;');
1022: li('g_last_update_login := hz_utility_v2pub.last_update_login;');
1017: li('p_program_id NUMBER := hz_utility_v2pub.program_id, ');
1018: li('p_program_application_id NUMBER := hz_utility_v2pub.program_application_id ');
1019: l(') IS');
1020: l('BEGIN');
1021: li('g_created_by := hz_utility_v2pub.created_by;');
1022: li('g_last_update_login := hz_utility_v2pub.last_update_login;');
1023: li('g_last_updated_by := hz_utility_v2pub.last_updated_by;');
1024: li('g_request_id := p_request_id;');
1025: li('g_program_id := p_program_id;');
1018: li('p_program_application_id NUMBER := hz_utility_v2pub.program_application_id ');
1019: l(') IS');
1020: l('BEGIN');
1021: li('g_created_by := hz_utility_v2pub.created_by;');
1022: li('g_last_update_login := hz_utility_v2pub.last_update_login;');
1023: li('g_last_updated_by := hz_utility_v2pub.last_updated_by;');
1024: li('g_request_id := p_request_id;');
1025: li('g_program_id := p_program_id;');
1026: li('g_program_application_id := p_program_application_id;');
1019: l(') IS');
1020: l('BEGIN');
1021: li('g_created_by := hz_utility_v2pub.created_by;');
1022: li('g_last_update_login := hz_utility_v2pub.last_update_login;');
1023: li('g_last_updated_by := hz_utility_v2pub.last_updated_by;');
1024: li('g_request_id := p_request_id;');
1025: li('g_program_id := p_program_id;');
1026: li('g_program_application_id := p_program_application_id;');
1027: l('END '||l_procedure_name||';');