127: l_child_workorder VARCHAR2(240);
128: l_wo_relationship_exc_tbl EAM_PROCESS_WO_PUB.wo_relationship_exc_tbl_type;
129: BEGIN
130:
131: -- Standard Start of API savepoint
132: SAVEPOINT EAM_WN_ADD_WO;
133:
134: -- Standard call to check for call compatibility.
135: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
130:
131: -- Standard Start of API savepoint
132: SAVEPOINT EAM_WN_ADD_WO;
133:
134: -- Standard call to check for call compatibility.
135: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
136: p_api_version ,
137: l_api_name ,
138: G_PKG_NAME )
716:
717: end if; --bug 7943516
718:
719: -- End of API body.
720: -- Standard check of p_commit.
721: IF FND_API.To_Boolean( p_commit ) THEN
722: --dbms_output.put_line('committing');
723: COMMIT WORK;
724: END IF;
923: BEGIN
924:
925: x_return_status := l_return_status;
926:
927: -- Standard Start of API savepoint
928: SAVEPOINT EAM_WN_RESIZE;
929:
930: EAM_WORKORDER_UTIL_PKG.log_path(l_output_dir);
931:
2493:
2494:
2495:
2496: BEGIN
2497: -- Standard Start of API savepoint
2498: SAVEPOINT EAM_WO_NETWORK_DEFAULT_PVT;
2499: -- Standard call to check for call compatibility.
2500: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2501: p_api_version ,
2495:
2496: BEGIN
2497: -- Standard Start of API savepoint
2498: SAVEPOINT EAM_WO_NETWORK_DEFAULT_PVT;
2499: -- Standard call to check for call compatibility.
2500: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2501: p_api_version ,
2502: l_api_name ,
2503: G_PKG_NAME )
2579:
2580:
2581:
2582: -- End of API body.
2583: -- Standard check of p_commit.
2584: IF FND_API.To_Boolean( p_commit ) THEN
2585: --dbms_output.put_line('committing');
2586: COMMIT WORK;
2587: END IF;
2584: IF FND_API.To_Boolean( p_commit ) THEN
2585: --dbms_output.put_line('committing');
2586: COMMIT WORK;
2587: END IF;
2588: -- Standard call to get message count and if count is 1, get message info.
2589: FND_MSG_PUB.Count_And_Get
2590: ( p_count => x_msg_count ,
2591: p_data => x_msg_data
2592: );
2669:
2670:
2671:
2672: BEGIN
2673: -- Standard Start of API savepoint
2674: SAVEPOINT EAM_WO_NETWORK_DEFAULT_PVT;
2675: -- Standard call to check for call compatibility.
2676: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2677: p_api_version ,
2671:
2672: BEGIN
2673: -- Standard Start of API savepoint
2674: SAVEPOINT EAM_WO_NETWORK_DEFAULT_PVT;
2675: -- Standard call to check for call compatibility.
2676: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2677: p_api_version ,
2678: l_api_name ,
2679: G_PKG_NAME )
2756:
2757:
2758:
2759: -- End of API body.
2760: -- Standard check of p_commit.
2761: IF FND_API.To_Boolean( p_commit ) THEN
2762: --dbms_output.put_line('committing');
2763: COMMIT WORK;
2764: END IF;
2761: IF FND_API.To_Boolean( p_commit ) THEN
2762: --dbms_output.put_line('committing');
2763: COMMIT WORK;
2764: END IF;
2765: -- Standard call to get message count and if count is 1, get message info.
2766: FND_MSG_PUB.Count_And_Get
2767: ( p_count => x_msg_count ,
2768: p_data => x_msg_data
2769: );
2852:
2853: l_exception_msg VARCHAR2(1000);
2854:
2855: BEGIN
2856: -- Standard Start of API savepoint
2857: SAVEPOINT EAM_WO_NETWORK_DEFAULT_PVT;
2858: -- Standard call to check for call compatibility.
2859: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2860: p_api_version ,
2854:
2855: BEGIN
2856: -- Standard Start of API savepoint
2857: SAVEPOINT EAM_WO_NETWORK_DEFAULT_PVT;
2858: -- Standard call to check for call compatibility.
2859: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2860: p_api_version ,
2861: l_api_name ,
2862: G_PKG_NAME )
3038: x_right_snap_window := l_next_level_min_window;
3039:
3040:
3041: -- End of API body.
3042: -- Standard check of p_commit.
3043: IF FND_API.To_Boolean( p_commit ) THEN
3044: --dbms_output.put_line('committing');
3045: COMMIT WORK;
3046: END IF;
3043: IF FND_API.To_Boolean( p_commit ) THEN
3044: --dbms_output.put_line('committing');
3045: COMMIT WORK;
3046: END IF;
3047: -- Standard call to get message count and if count is 1, get message info.
3048: FND_MSG_PUB.Count_And_Get
3049: ( p_count => x_msg_count ,
3050: p_data => x_msg_data
3051: );
3135:
3136: l_exception_msg VARCHAR2(1000);
3137:
3138: BEGIN
3139: -- Standard Start of API savepoint
3140: SAVEPOINT EAM_WO_NETWORK_DEFAULT_PVT;
3141: -- Standard call to check for call compatibility.
3142: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
3143: p_api_version ,
3137:
3138: BEGIN
3139: -- Standard Start of API savepoint
3140: SAVEPOINT EAM_WO_NETWORK_DEFAULT_PVT;
3141: -- Standard call to check for call compatibility.
3142: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
3143: p_api_version ,
3144: l_api_name ,
3145: G_PKG_NAME )
3319: x_left_snap_window := l_next_level_min_window;
3320:
3321:
3322: -- End of API body.
3323: -- Standard check of p_commit.
3324: IF FND_API.To_Boolean( p_commit ) THEN
3325: --dbms_output.put_line('committing');
3326: COMMIT WORK;
3327: END IF;
3324: IF FND_API.To_Boolean( p_commit ) THEN
3325: --dbms_output.put_line('committing');
3326: COMMIT WORK;
3327: END IF;
3328: -- Standard call to get message count and if count is 1, get message info.
3329: FND_MSG_PUB.Count_And_Get
3330: ( p_count => x_msg_count ,
3331: p_data => x_msg_data
3332: );
3428: AND WSR.RELATIONSHIP_TYPE = 1;
3429:
3430:
3431: BEGIN
3432: -- Standard Start of API savepoint
3433:
3434: -- Standard call to check for call compatibility.
3435: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
3436: p_api_version ,
3430:
3431: BEGIN
3432: -- Standard Start of API savepoint
3433:
3434: -- Standard call to check for call compatibility.
3435: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
3436: p_api_version ,
3437: l_api_name ,
3438: G_PKG_NAME )
3569: END IF;
3570: */
3571:
3572: -- End of API body.
3573: -- Standard check of p_commit.
3574: IF FND_API.To_Boolean( p_commit ) THEN
3575: --dbms_output.put_line('committing');
3576: COMMIT WORK;
3577: END IF;
3574: IF FND_API.To_Boolean( p_commit ) THEN
3575: --dbms_output.put_line('committing');
3576: COMMIT WORK;
3577: END IF;
3578: -- Standard call to get message count and if count is 1, get message info.
3579: FND_MSG_PUB.Count_And_Get
3580: ( p_count => x_msg_count ,
3581: p_data => x_msg_data
3582: );
3682: AND WSR.RELATIONSHIP_TYPE = 1;
3683:
3684:
3685: BEGIN
3686: -- Standard Start of API savepoint
3687:
3688: -- Standard call to check for call compatibility.
3689: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
3690: p_api_version ,
3684:
3685: BEGIN
3686: -- Standard Start of API savepoint
3687:
3688: -- Standard call to check for call compatibility.
3689: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
3690: p_api_version ,
3691: l_api_name ,
3692: G_PKG_NAME )
3824: */
3825:
3826:
3827: -- End of API body.
3828: -- Standard check of p_commit.
3829: IF FND_API.To_Boolean( p_commit ) THEN
3830: --dbms_output.put_line('committing');
3831: COMMIT WORK;
3832: END IF;
3829: IF FND_API.To_Boolean( p_commit ) THEN
3830: --dbms_output.put_line('committing');
3831: COMMIT WORK;
3832: END IF;
3833: -- Standard call to get message count and if count is 1, get message info.
3834: FND_MSG_PUB.Count_And_Get
3835: ( p_count => x_msg_count ,
3836: p_data => x_msg_data
3837: );