eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_OPERATIONS_JSP dependencies on STANDARD

Line 788: l_eam_op_rec.standard_operation_id := opRow.Standard_Operation_Id;

784: l_eam_op_rec.wip_entity_id := opRow.Wip_Entity_Id;
785: l_eam_op_rec.operation_seq_num := opRow.Operation_Seq_Num;
786: l_eam_op_rec.organization_id := opRow.Organization_Id;
787: l_eam_op_rec.operation_sequence_id := opRow.Operation_Sequence_Id;
788: l_eam_op_rec.standard_operation_id := opRow.Standard_Operation_Id;
789: l_eam_op_rec.department_id := opRow.Department_Id;
790: l_eam_op_rec.description := opRow.Description;
791: l_eam_op_rec.start_date := opRow.First_Unit_Start_Date;
792: l_eam_op_rec.completion_date := opRow.Last_Unit_Completion_Date;

Line 1542: l_eam_res_rec.standard_rate_flag := newRow.standard_rate_flag;

1538: l_eam_res_rec.firm_flag := newRow.firm_flag;
1539: l_eam_res_rec.assigned_units := newRow.assigned_units;
1540: l_eam_res_rec.maximum_assigned_units := newRow.maximum_assigned_units;
1541: l_eam_res_rec.autocharge_type := newRow.autocharge_type;
1542: l_eam_res_rec.standard_rate_flag := newRow.standard_rate_flag;
1543: l_eam_res_rec.applied_resource_units := newRow.applied_resource_units;
1544: l_eam_res_rec.applied_resource_value := newRow.applied_resource_value;
1545: l_eam_res_rec.start_date := newRow.start_date;
1546: l_eam_res_rec.completion_date := newRow.completion_date;

Line 1959: -- Standard Start of API savepoint

1955:
1956: EAM_WORKORDER_UTIL_PKG.log_path(l_output_dir);
1957:
1958:
1959: -- Standard Start of API savepoint
1960: l_stmt_num := 10;
1961: SAVEPOINT get_insert_into_wor_pvt;
1962:
1963: l_stmt_num := 20;

Line 1964: -- Standard call to check for call compatibility.

1960: l_stmt_num := 10;
1961: SAVEPOINT get_insert_into_wor_pvt;
1962:
1963: l_stmt_num := 20;
1964: -- Standard call to check for call compatibility.
1965: IF NOT fnd_api.compatible_api_call(
1966: l_api_version
1967: ,p_api_version
1968: ,l_api_name

Line 2061: l_eam_res_rec.standard_rate_flag := 1;

2057: l_eam_res_rec.scheduled_flag := p_scheduled_flag;
2058: l_eam_res_rec.assigned_units := p_assigned_units;
2059: l_eam_res_rec.autocharge_type := p_charge_type;
2060: if ( p_std_rate = 'Y') then
2061: l_eam_res_rec.standard_rate_flag := 1;
2062: else
2063: l_eam_res_rec.standard_rate_flag := 2;
2064: end if;
2065: l_eam_res_rec.start_date := p_start_date;

Line 2063: l_eam_res_rec.standard_rate_flag := 2;

2059: l_eam_res_rec.autocharge_type := p_charge_type;
2060: if ( p_std_rate = 'Y') then
2061: l_eam_res_rec.standard_rate_flag := 1;
2062: else
2063: l_eam_res_rec.standard_rate_flag := 2;
2064: end if;
2065: l_eam_res_rec.start_date := p_start_date;
2066: l_eam_res_rec.completion_date := p_end_date;
2067: l_eam_res_rec.schedule_seq_num := p_schedule_sequence;

Line 2143: l_eam_res_rec.standard_rate_flag := 1;

2139: l_eam_res_rec.scheduled_flag := p_scheduled_flag;
2140: l_eam_res_rec.assigned_units := p_assigned_units;
2141: l_eam_res_rec.autocharge_type := p_charge_type;
2142: if ( p_std_rate = 'Y') then
2143: l_eam_res_rec.standard_rate_flag := 1;
2144: else
2145: l_eam_res_rec.standard_rate_flag := 2;
2146: end if;
2147: l_eam_res_rec.start_date := p_start_date;

Line 2145: l_eam_res_rec.standard_rate_flag := 2;

2141: l_eam_res_rec.autocharge_type := p_charge_type;
2142: if ( p_std_rate = 'Y') then
2143: l_eam_res_rec.standard_rate_flag := 1;
2144: else
2145: l_eam_res_rec.standard_rate_flag := 2;
2146: end if;
2147: l_eam_res_rec.start_date := p_start_date;
2148: l_eam_res_rec.completion_date := p_end_date;
2149: l_eam_res_rec.schedule_seq_num := p_schedule_sequence;

Line 2209: -- Standard check of p_commit.

2205: x_update_status := l_update_status;
2206:
2207:
2208: -- End of API body.
2209: -- Standard check of p_commit.
2210: IF fnd_api.to_boolean(p_commit)
2211: and x_return_status = 'S' THEN
2212: COMMIT WORK;
2213: END IF;

Line 2221: -- Standard call to get message count and if count is 1, get message info.

2217: END IF;
2218:
2219:
2220: l_stmt_num := 999;
2221: -- Standard call to get message count and if count is 1, get message info.
2222: fnd_msg_pub.count_and_get(
2223: p_count => x_msg_count
2224: ,p_data => x_msg_data);
2225: EXCEPTION

Line 2575: -- Standard Start of API savepoint

2571:
2572: l_output_dir VARCHAR2(512);
2573:
2574: BEGIN
2575: -- Standard Start of API savepoint
2576: l_stmt_num := 10;
2577: SAVEPOINT get_insert_into_wro_pvt;
2578:
2579: l_stmt_num := 20;

Line 2580: -- Standard call to check for call compatibility.

2576: l_stmt_num := 10;
2577: SAVEPOINT get_insert_into_wro_pvt;
2578:
2579: l_stmt_num := 20;
2580: -- Standard call to check for call compatibility.
2581: IF NOT fnd_api.compatible_api_call(
2582: l_api_version
2583: ,p_api_version
2584: ,l_api_name

Line 2873: -- Standard check of p_commit.

2869: x_update_status := l_update_status;
2870:
2871:
2872: -- End of API body.
2873: -- Standard check of p_commit.
2874: IF fnd_api.to_boolean(p_commit)
2875: and x_return_status = 'S' THEN
2876: COMMIT WORK;
2877: END IF;

Line 2884: -- Standard call to get message count and if count is 1, get message info.

2880: ROLLBACK TO get_insert_into_wro_pvt;
2881: END IF;
2882:
2883: l_stmt_num := 999;
2884: -- Standard call to get message count and if count is 1, get message info.
2885: fnd_msg_pub.count_and_get(
2886: p_count => x_msg_count
2887: ,p_data => x_msg_data);
2888: EXCEPTION

Line 2994: -- Standard Start of API savepoint

2990:
2991: l_output_dir VARCHAR2(512);
2992:
2993: BEGIN
2994: -- Standard Start of API savepoint
2995: l_stmt_num := 10;
2996: SAVEPOINT get_delete_resources_pvt;
2997:
2998: l_stmt_num := 20;

Line 2999: -- Standard call to check for call compatibility.

2995: l_stmt_num := 10;
2996: SAVEPOINT get_delete_resources_pvt;
2997:
2998: l_stmt_num := 20;
2999: -- Standard call to check for call compatibility.
3000: IF NOT fnd_api.compatible_api_call(
3001: l_api_version
3002: ,p_api_version
3003: ,l_api_name

Line 3154: -- Standard check of p_commit.

3150:
3151:
3152:
3153: -- End of API body.
3154: -- Standard check of p_commit.
3155: IF fnd_api.to_boolean(p_commit)
3156: and x_return_status = 'S' THEN
3157: COMMIT WORK;
3158: END IF;

Line 3166: -- Standard call to get message count and if count is 1, get message info.

3162: END IF;
3163:
3164: l_stmt_num := 999;
3165:
3166: -- Standard call to get message count and if count is 1, get message info.
3167: fnd_msg_pub.count_and_get(
3168: p_count => x_msg_count
3169: ,p_data => x_msg_data);
3170:

Line 3290: -- Procedure to validate standard operation

3286:
3287:
3288:
3289: --------------------------------------------------------------------------
3290: -- Procedure to validate standard operation
3291: -- Used in Operations Page
3292: -- Author : rethakur
3293: --------------------------------------------------------------------------
3294:

Line 3297: ,x_standard_operation_id OUT NOCOPY NUMBER

3293: --------------------------------------------------------------------------
3294:
3295: procedure validate_std_operation ( p_organization_id IN NUMBER
3296: ,p_operation_code IN VARCHAR2
3297: ,x_standard_operation_id OUT NOCOPY NUMBER
3298: ,x_department_id OUT NOCOPY NUMBER
3299: ,x_shutdown_type OUT NOCOPY VARCHAR2
3300: ,x_return_status OUT NOCOPY NUMBER) IS
3301:

Line 3302: l_standard_operation_id NUMBER := null;

3298: ,x_department_id OUT NOCOPY NUMBER
3299: ,x_shutdown_type OUT NOCOPY VARCHAR2
3300: ,x_return_status OUT NOCOPY NUMBER) IS
3301:
3302: l_standard_operation_id NUMBER := null;
3303: l_department_id NUMBER := null;
3304: l_shutdown_type VARCHAR2(10);
3305: l_return_status NUMBER := 0;
3306:

Line 3309: SELECT bdp.department_id, bso.standard_operation_id,

3305: l_return_status NUMBER := 0;
3306:
3307: BEGIN
3308:
3309: SELECT bdp.department_id, bso.standard_operation_id,
3310: bso.shutdown_type
3311: INTO l_department_id, l_standard_operation_id,
3312: l_shutdown_type
3313: FROM BOM_DEPARTMENTS bdp,

Line 3311: INTO l_department_id, l_standard_operation_id,

3307: BEGIN
3308:
3309: SELECT bdp.department_id, bso.standard_operation_id,
3310: bso.shutdown_type
3311: INTO l_department_id, l_standard_operation_id,
3312: l_shutdown_type
3313: FROM BOM_DEPARTMENTS bdp,
3314: BOM_STANDARD_OPERATIONS bso
3315: WHERE bso.organization_id = p_organization_id

Line 3314: BOM_STANDARD_OPERATIONS bso

3310: bso.shutdown_type
3311: INTO l_department_id, l_standard_operation_id,
3312: l_shutdown_type
3313: FROM BOM_DEPARTMENTS bdp,
3314: BOM_STANDARD_OPERATIONS bso
3315: WHERE bso.organization_id = p_organization_id
3316: AND bso.operation_code = p_operation_code
3317: AND bso.line_id IS NULL
3318: AND NVL ( bso.operation_type, 1) = 1

Line 3325: x_standard_operation_id := l_standard_operation_id;

3321: AND NVL ( bdp.disable_date, sysdate + 2) > sysdate ;
3322:
3323: x_return_status := l_return_status;
3324: x_department_id := l_department_id;
3325: x_standard_operation_id := l_standard_operation_id;
3326: x_shutdown_type := l_shutdown_type;
3327:
3328: EXCEPTION
3329: WHEN NO_DATA_FOUND THEN

Line 3333: x_standard_operation_id := null;

3329: WHEN NO_DATA_FOUND THEN
3330: l_return_status := 1;
3331: x_return_status := l_return_status ;
3332: x_department_id := null;
3333: x_standard_operation_id := null;
3334: x_shutdown_type := null;
3335: END validate_std_operation;
3336:
3337: --------------------------------------------------------------------------

Line 3344: ,p_standard_operation_id IN NUMBER

3340: -- Author : rethakur
3341: --------------------------------------------------------------------------
3342: procedure insert_into_wo ( p_wip_entity_id IN NUMBER
3343: ,p_operation_seq_num IN NUMBER
3344: ,p_standard_operation_id IN NUMBER
3345: ,p_organization_id IN NUMBER
3346: ,p_description IN VARCHAR2
3347: ,p_department_id IN NUMBER
3348: ,p_shutdown_type IN VARCHAR2

Line 3409: FROM bom_standard_operations bso,

3405: invalid_autochrg_exp EXCEPTION;
3406:
3407: CURSOR chk_autocharge IS
3408: SELECT 1
3409: FROM bom_standard_operations bso,
3410: bom_std_op_resources bsor
3411: WHERE bso.standard_operation_id = bsor.standard_operation_id
3412: AND bsor.standard_operation_id = p_standard_operation_id
3413: AND bso.organization_id = p_organization_id

Line 3411: WHERE bso.standard_operation_id = bsor.standard_operation_id

3407: CURSOR chk_autocharge IS
3408: SELECT 1
3409: FROM bom_standard_operations bso,
3410: bom_std_op_resources bsor
3411: WHERE bso.standard_operation_id = bsor.standard_operation_id
3412: AND bsor.standard_operation_id = p_standard_operation_id
3413: AND bso.organization_id = p_organization_id
3414: AND bsor.autocharge_type NOT IN (2,3);
3415:

Line 3412: AND bsor.standard_operation_id = p_standard_operation_id

3408: SELECT 1
3409: FROM bom_standard_operations bso,
3410: bom_std_op_resources bsor
3411: WHERE bso.standard_operation_id = bsor.standard_operation_id
3412: AND bsor.standard_operation_id = p_standard_operation_id
3413: AND bso.organization_id = p_organization_id
3414: AND bsor.autocharge_type NOT IN (2,3);
3415:
3416: BEGIN

Line 3444: if ( nvl(p_standard_operation_id,0)= 0 ) then -- added OR clause for bug#3541316

3440: l_eam_op_rec.long_description := p_long_description;
3441: l_eam_op_rec.shutdown_type := p_shutdown_type;
3442: l_eam_op_rec.start_date := l_first_unit_start_date;
3443: l_eam_op_rec.completion_date := l_last_unit_completion_date;
3444: if ( nvl(p_standard_operation_id,0)= 0 ) then -- added OR clause for bug#3541316
3445: l_eam_op_rec.standard_operation_id := null ;
3446: else -- added else clause for bug#3518663
3447: l_eam_op_rec.standard_operation_id := p_standard_operation_id;
3448: end if;

Line 3445: l_eam_op_rec.standard_operation_id := null ;

3441: l_eam_op_rec.shutdown_type := p_shutdown_type;
3442: l_eam_op_rec.start_date := l_first_unit_start_date;
3443: l_eam_op_rec.completion_date := l_last_unit_completion_date;
3444: if ( nvl(p_standard_operation_id,0)= 0 ) then -- added OR clause for bug#3541316
3445: l_eam_op_rec.standard_operation_id := null ;
3446: else -- added else clause for bug#3518663
3447: l_eam_op_rec.standard_operation_id := p_standard_operation_id;
3448: end if;
3449: l_eam_op_rec.department_id := p_department_id;

Line 3447: l_eam_op_rec.standard_operation_id := p_standard_operation_id;

3443: l_eam_op_rec.completion_date := l_last_unit_completion_date;
3444: if ( nvl(p_standard_operation_id,0)= 0 ) then -- added OR clause for bug#3541316
3445: l_eam_op_rec.standard_operation_id := null ;
3446: else -- added else clause for bug#3518663
3447: l_eam_op_rec.standard_operation_id := p_standard_operation_id;
3448: end if;
3449: l_eam_op_rec.department_id := p_department_id;
3450:
3451: l_eam_op_tbl(1) := l_eam_op_rec ;

Line 4826: -- Standard check of p_commit.

4822: IF(x_return_status <>'S') THEN
4823: ROLLBACK TO update_wro;
4824: END IF;
4825:
4826: -- Standard check of p_commit.
4827: IF fnd_api.to_boolean(p_commit)
4828: and x_return_status = 'S' THEN
4829: COMMIT WORK;
4830: END IF;

Line 4908: -- Standard Start of API savepoint

4904:
4905: l_output_dir VARCHAR2(512);
4906:
4907: BEGIN
4908: -- Standard Start of API savepoint
4909: l_stmt_num := 10;
4910: SAVEPOINT delete_instance_pvt;
4911:
4912: l_stmt_num := 20;

Line 4913: -- Standard call to check for call compatibility.

4909: l_stmt_num := 10;
4910: SAVEPOINT delete_instance_pvt;
4911:
4912: l_stmt_num := 20;
4913: -- Standard call to check for call compatibility.
4914: IF NOT fnd_api.compatible_api_call(
4915: l_api_version
4916: ,p_api_version
4917: ,l_api_name

Line 4998: -- Standard check of p_commit.

4994: );
4995:
4996:
4997: -- End of API body.
4998: -- Standard check of p_commit.
4999: IF fnd_api.to_boolean(p_commit)
5000: and x_return_status = 'S' THEN
5001: COMMIT WORK;
5002: END IF;

Line 5010: -- Standard call to get message count and if count is 1, get message info.

5006: END IF;
5007:
5008: l_stmt_num := 999;
5009:
5010: -- Standard call to get message count and if count is 1, get message info.
5011: fnd_msg_pub.count_and_get(
5012: p_count => x_msg_count
5013: ,p_data => x_msg_data);
5014: