DBA Data[Home] [Help]

APPS.HZ_MIXNM_DYNAMIC_PKG_GENERATOR dependencies on HZ_UTILITY_V2PUB

Line 454: l_apps_schema := hz_utility_v2pub.Get_AppsSchemaName;

450: l_ar_schema VARCHAR2(255);
451: l_bool BOOLEAN;
452: BEGIN
453:
454: l_apps_schema := hz_utility_v2pub.Get_AppsSchemaName;
455: l_ar_schema := hz_utility_v2pub.Get_SchemaName('AR');
456:
457: IF G_SETUP_LOADED = 'Y' THEN
458: RETURN;

Line 455: l_ar_schema := hz_utility_v2pub.Get_SchemaName('AR');

451: l_bool BOOLEAN;
452: BEGIN
453:
454: l_apps_schema := hz_utility_v2pub.Get_AppsSchemaName;
455: l_ar_schema := hz_utility_v2pub.Get_SchemaName('AR');
456:
457: IF G_SETUP_LOADED = 'Y' THEN
458: RETURN;
459: END IF;

Line 1102: li('p_request_id NUMBER := hz_utility_v2pub.request_id, ');

1098:
1099: l_procedure_name := 'reset_who';
1100:
1101: l('PROCEDURE '||l_procedure_name || ' (');
1102: li('p_request_id NUMBER := hz_utility_v2pub.request_id, ');
1103: li('p_program_id NUMBER := hz_utility_v2pub.program_id, ');
1104: li('p_program_application_id NUMBER := hz_utility_v2pub.program_application_id ');
1105: l(') IS');
1106: l('BEGIN');

Line 1103: li('p_program_id NUMBER := hz_utility_v2pub.program_id, ');

1099: l_procedure_name := 'reset_who';
1100:
1101: l('PROCEDURE '||l_procedure_name || ' (');
1102: li('p_request_id NUMBER := hz_utility_v2pub.request_id, ');
1103: li('p_program_id NUMBER := hz_utility_v2pub.program_id, ');
1104: li('p_program_application_id NUMBER := hz_utility_v2pub.program_application_id ');
1105: l(') IS');
1106: l('BEGIN');
1107: li('g_created_by := hz_utility_v2pub.created_by;');

Line 1104: li('p_program_application_id NUMBER := hz_utility_v2pub.program_application_id ');

1100:
1101: l('PROCEDURE '||l_procedure_name || ' (');
1102: li('p_request_id NUMBER := hz_utility_v2pub.request_id, ');
1103: li('p_program_id NUMBER := hz_utility_v2pub.program_id, ');
1104: li('p_program_application_id NUMBER := hz_utility_v2pub.program_application_id ');
1105: l(') IS');
1106: l('BEGIN');
1107: li('g_created_by := hz_utility_v2pub.created_by;');
1108: li('g_last_update_login := hz_utility_v2pub.last_update_login;');

Line 1107: li('g_created_by := hz_utility_v2pub.created_by;');

1103: li('p_program_id NUMBER := hz_utility_v2pub.program_id, ');
1104: li('p_program_application_id NUMBER := hz_utility_v2pub.program_application_id ');
1105: l(') IS');
1106: l('BEGIN');
1107: li('g_created_by := hz_utility_v2pub.created_by;');
1108: li('g_last_update_login := hz_utility_v2pub.last_update_login;');
1109: li('g_last_updated_by := hz_utility_v2pub.last_updated_by;');
1110: li('g_request_id := p_request_id;');
1111: li('g_program_id := p_program_id;');

Line 1108: li('g_last_update_login := hz_utility_v2pub.last_update_login;');

1104: li('p_program_application_id NUMBER := hz_utility_v2pub.program_application_id ');
1105: l(') IS');
1106: l('BEGIN');
1107: li('g_created_by := hz_utility_v2pub.created_by;');
1108: li('g_last_update_login := hz_utility_v2pub.last_update_login;');
1109: li('g_last_updated_by := hz_utility_v2pub.last_updated_by;');
1110: li('g_request_id := p_request_id;');
1111: li('g_program_id := p_program_id;');
1112: li('g_program_application_id := p_program_application_id;');

Line 1109: li('g_last_updated_by := hz_utility_v2pub.last_updated_by;');

1105: l(') IS');
1106: l('BEGIN');
1107: li('g_created_by := hz_utility_v2pub.created_by;');
1108: li('g_last_update_login := hz_utility_v2pub.last_update_login;');
1109: li('g_last_updated_by := hz_utility_v2pub.last_updated_by;');
1110: li('g_request_id := p_request_id;');
1111: li('g_program_id := p_program_id;');
1112: li('g_program_application_id := p_program_application_id;');
1113: l('END '||l_procedure_name||';');