[Home] [Help]
225: l_api_version CONSTANT NUMBER := 1.0;
226:
227: BEGIN
228: code_debug ( l_api_name || ' Start ');
229: -- Standard start of API savepoint
230: IF FND_API.To_Boolean(p_commit) THEN
231: SAVEPOINT Delete_Action_Data_Level;
232: END IF;
233:
244:
245: DELETE FROM EGO_ACTIONS_DL
246: WHERE ACTION_ID = p_action_id;
247:
248: -- Standard check of p_commit
249: IF FND_API.To_Boolean(p_commit) THEN
250: COMMIT WORK;
251: END IF;
252: x_return_status := FND_API.G_RET_STS_SUCCESS;
926: l_app_col_name VARCHAR2(30);
927:
928: BEGIN
929:
930: -- Standard start of API savepoint
931: IF FND_API.TO_BOOLEAN(p_commit) THEN
932: SAVEPOINT Delete_Attribute_PRV;
933: END IF;
934:
957: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
958: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name
959: AND APPLICATION_COLUMN_NAME = l_app_col_name;
960:
961: -- Standard check of p_commit
962: IF FND_API.To_Boolean(p_commit) THEN
963: COMMIT WORK;
964: END IF;
965:
1006: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name;
1007:
1008: BEGIN
1009:
1010: -- Standard start of API savepoint
1011: IF FND_API.TO_BOOLEAN(p_commit) THEN
1012: SAVEPOINT Delete_Attribute_Group_PVT;
1013: END IF;
1014:
1041: WHERE APPLICATION_ID = p_application_id
1042: AND ATTR_GROUP_TYPE = p_attr_group_type
1043: AND ATTR_GROUP_NAME = p_attr_group_name);
1044:
1045: -- Standard check of p_commit
1046: IF FND_API.To_Boolean(p_commit) THEN
1047: COMMIT WORK;
1048: END IF;
1049:
2311:
2312:
2313: BEGIN
2314:
2315: -- Standard start of API savepoint
2316: IF FND_API.To_Boolean(p_commit) THEN
2317: SAVEPOINT Create_Attribute_Group_PUB;
2318: END IF;
2319:
2574:
2575: EXECUTE IMMEDIATE l_dynamic_sql;
2576: END IF;
2577: END IF;
2578: -- Standard check of p_commit
2579: IF FND_API.To_Boolean(p_commit) THEN
2580: COMMIT WORK;
2581: END IF;
2582: x_return_status := FND_API.G_RET_STS_SUCCESS;
2777: l_sequence_numbers VARCHAR2(10000);
2778:
2779: BEGIN
2780:
2781: -- Standard start of API savepoint
2782: IF FND_API.TO_BOOLEAN(p_commit) THEN
2783: SAVEPOINT Copy_Attribute_Group_PUB;
2784: END IF;
2785:
2852: );
2853: END LOOP;
2854: CLOSE ego_attribute_csr;
2855:
2856: -- Standard check of p_commit
2857: IF FND_API.To_Boolean(p_commit) THEN
2858: COMMIT WORK;
2859: END IF;
2860:
2998: l_attr_group_pks EGO_VARCHAR_TBL_TYPE;
2999:
3000: BEGIN
3001:
3002: -- Standard start of API savepoint
3003: IF FND_API.TO_BOOLEAN(p_commit) THEN
3004: SAVEPOINT Update_Attribute_Group_PUB;
3005: END IF;
3006:
3034: ,x_msg_count => x_msg_count
3035: ,x_msg_data => x_msg_data
3036: );
3037:
3038: -- Standard check of p_commit
3039: IF FND_API.To_Boolean(p_commit) THEN
3040: COMMIT WORK;
3041: END IF;
3042:
3105:
3106:
3107: BEGIN
3108:
3109: -- Standard start of API savepoint
3110: IF FND_API.TO_BOOLEAN(p_commit) THEN
3111: SAVEPOINT Update_Attribute_Group_PUB;
3112: END IF;
3113:
3187: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_internal_name
3188: -- AND LANGUAGE = USERENV('LANG');
3189: AND USERENV('LANG') in (LANGUAGE , SOURCE_LANG);
3190:
3191: -- Standard check of p_commit
3192: IF FND_API.To_Boolean(p_commit) THEN
3193: COMMIT WORK;
3194: END IF;
3195:
3229: l_attr_group_pks EGO_VARCHAR_TBL_TYPE;
3230:
3231: BEGIN
3232:
3233: -- Standard start of API savepoint
3234: IF FND_API.TO_BOOLEAN(p_commit) THEN
3235: SAVEPOINT Delete_Attribute_Group_PUB;
3236: END IF;
3237:
3252: ,x_msg_count => x_msg_count
3253: ,x_msg_data => x_msg_data
3254: );
3255:
3256: -- Standard check of p_commit
3257: IF FND_API.To_Boolean(p_commit) THEN
3258: COMMIT WORK;
3259: END IF;
3260:
3307: l_attr_group_disp_name VARCHAR2(80);
3308:
3309: BEGIN
3310:
3311: -- Standard start of API savepoint
3312: IF FND_API.TO_BOOLEAN(p_commit) THEN
3313: SAVEPOINT Delete_Attribute_Group_PUB;
3314: END IF;
3315:
3360: ,x_msg_data);
3361:
3362: END IF;
3363:
3364: -- Standard check of p_commit
3365: IF FND_API.To_Boolean(p_commit) THEN
3366: COMMIT WORK;
3367: END IF;
3368:
3422:
3423:
3424: BEGIN
3425:
3426: -- Standard start of API savepoint
3427: IF FND_API.TO_BOOLEAN(p_commit) THEN
3428: SAVEPOINT Compile_Attr_Group_View_PUB;
3429: END IF;
3430:
3808: END IF;
3809: --Bug : 10097736 Added to check for view before commiting
3810: Check_Attr_Group_View(p_attr_group_id);
3811:
3812: -- Standard check of p_commit
3813: IF FND_API.To_Boolean(p_commit) THEN
3814: COMMIT WORK;
3815: END IF;
3816:
4312: THEN
4313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4314: END IF;
4315:
4316: -- Standard start of API savepoint
4317: IF FND_API.TO_BOOLEAN(p_commit) THEN
4318: SAVEPOINT SYNC_DATA_LEVEL;
4319: END IF;
4320:
4596: END IF;
4597:
4598:
4599:
4600: -- Standard start of API savepoint
4601: IF FND_API.TO_BOOLEAN(p_commit) THEN
4602: SAVEPOINT SYNC_DL_ASSOC;
4603: END IF;
4604:
5098: l_min_seq NUMBER;
5099:
5100: BEGIN
5101:
5102: -- Standard start of API savepoint
5103: IF FND_API.TO_BOOLEAN(p_commit) THEN
5104: SAVEPOINT Create_Attribute_PUB;
5105: END IF;
5106:
5630: ,p_lud -- LAST_UPDATE_DATE
5631: ,g_current_login_id -- LAST_UPDATE_LOGIN
5632: FROM DUAL;
5633:
5634: -- Standard check of p_commit
5635: IF FND_API.To_Boolean(p_commit) THEN
5636: COMMIT WORK;
5637: END IF;
5638: x_return_status := FND_API.G_RET_STS_SUCCESS;
5966: e_default_value_len_err EXCEPTION;
5967:
5968:
5969: BEGIN
5970: -- Standard start of API savepoint
5971: IF FND_API.To_Boolean(p_commit) THEN
5972: SAVEPOINT Update_Attribute_PUB;
5973: END IF;
5974:
6298: AND APPLICATION_COLUMN_NAME = p_column
6299: --AND LANGUAGE = USERENV('LANG');
6300: AND USERENV('LANG') in (LANGUAGE , SOURCE_LANG);
6301:
6302: -- Standard check of p_commit
6303: IF FND_API.To_Boolean(p_commit) THEN
6304: COMMIT WORK;
6305: END IF;
6306:
6961: code_debug(' Started '||l_api_name ||' with params ');
6962: code_debug('p_value_set_name - '|| p_value_set_name||' p_description - '||p_description);
6963: code_debug('p_maximum_size - '|| p_maximum_size||' p_maximum_value - '||p_maximum_value||' p_minimum_value - '||p_minimum_value);
6964: code_debug('p_format_code - '|| p_format_code||' p_validation_code - '||p_validation_code||' p_long_list_flag - '||p_long_list_flag);
6965: -- Standard start of API savepoint
6966: IF FND_API.To_Boolean(p_commit) THEN
6967: SAVEPOINT Create_Value_Set_PUB;
6968: END IF;
6969:
7153: INTO x_value_set_id
7154: FROM fnd_flex_value_sets
7155: WHERE flex_value_set_name = p_value_set_name;
7156:
7157: -- Standard check of p_commit
7158: IF FND_API.To_Boolean(p_commit) THEN
7159: COMMIT WORK;
7160: END IF;
7161:
7247: ' p_value_set_name - ' || p_value_set_name ||
7248: ' p_description - ' || p_description ||
7249: ' p_parent_vs_id - ' || p_parent_vs_id );
7250:
7251: -- Standard start of API savepoint
7252: IF FND_API.To_Boolean(p_commit) THEN
7253: SAVEPOINT Create_Child_Value_Set_PUB;
7254: END IF;
7255:
7577: l_api_name := 'Update_Value_Set';
7578: l_api_version := 1.0;
7579: l_Sysdate := SYSDATE;
7580:
7581: -- Standard start of API savepoint
7582: IF FND_API.To_Boolean(p_commit) THEN
7583: SAVEPOINT Update_Value_Set_PUB;
7584: END IF;
7585:
7695: -- dbms_output.put_line(' ' || l_value_set_rec.value_set_id);
7696: END LOOP child_value_set_ids_loop;
7697:
7698:
7699: -- Standard check of p_commit
7700: IF FND_API.To_Boolean(p_commit) THEN
7701: COMMIT WORK;
7702: END IF;
7703:
7782: ' with params:' ||
7783: ' p_value_set_id - ' || p_value_set_id ||
7784: ' p_description - ' || p_description );
7785:
7786: -- Standard start of API savepoint
7787: IF FND_API.To_Boolean(p_commit) THEN
7788: SAVEPOINT Update_Child_Value_Set_PUB;
7789: END IF;
7790:
7995: l_api_version := 1.0;
7996: l_Sysdate := SYSDATE;
7997: code_debug(l_api_name ||' start ');
7998:
7999: -- Standard start of API savepoint
8000: IF FND_API.To_Boolean(p_commit) THEN
8001: SAVEPOINT Insert_Value_Set_Table_Inf_PUB;
8002: END IF;
8003:
8097: ,g_current_login_id --LAST_UPDATE_LOGIN
8098: );
8099:
8100: code_debug(l_api_name ||' inserting data into fnd_flex_validation_tables COMPLETED ');
8101: -- Standard check of p_commit
8102: IF FND_API.To_Boolean(p_commit) THEN
8103: COMMIT WORK;
8104: END IF;
8105:
8174: l_api_version := 1.0;
8175: l_Sysdate := SYSDATE;
8176:
8177: code_debug(l_api_name ||' start ');
8178: -- Standard start of API savepoint
8179: IF FND_API.To_Boolean(p_commit) THEN
8180: SAVEPOINT Update_Value_Set_Table_Inf_PUB;
8181: END IF;
8182:
8240: LAST_UPDATE_LOGIN = g_current_login_id
8241: WHERE FLEX_VALUE_SET_ID = p_value_set_id;
8242:
8243: code_debug(l_api_name ||' calling update fnd_flex_validation_tables COMPLETED ');
8244: -- Standard check of p_commit
8245: IF FND_API.To_Boolean(p_commit) THEN
8246: COMMIT WORK;
8247: END IF;
8248:
8435:
8436: l_api_name := 'Create_Value_Set_Val';
8437: l_api_version := 1.0;
8438:
8439: -- Standard start of API savepoint
8440: IF FND_API.To_Boolean(p_commit) THEN
8441: SAVEPOINT Create_Value_Set_Val_PUB;
8442: END IF;
8443:
8630:
8631: l_api_name := 'Update_Value_Set_Val';
8632: l_api_version := 1.0;
8633:
8634: -- Standard start of API savepoint
8635: IF FND_API.To_Boolean(p_commit) THEN
8636: SAVEPOINT Update_Value_Set_Val_PUB;
8637: END IF;
8638:
8719: -- Bug 9803134
8720: x_valueSetId := l_value_set_id;
8721:
8722: END IF ;
8723: -- Standard check of p_commit
8724: IF FND_API.To_Boolean(p_commit) THEN
8725: COMMIT WORK;
8726: END IF;
8727:
9102: END IF;
9103:
9104: code_debug(l_api_name||' msg pub initialized ' );
9105: --
9106: --Standard checks
9107: --
9108: IF NOT FND_API.Compatible_API_Call (l_api_version
9109: ,p_api_version
9110: ,l_api_name
9307:
9308:
9309: BEGIN
9310:
9311: -- Standard start of API savepoint
9312: IF FND_API.To_Boolean(p_commit) THEN
9313: SAVEPOINT Create_Association_PUB;
9314: END IF;
9315:
9490: CLOSE data_level_merge;
9491:
9492: END IF;
9493:
9494: -- Standard check of p_commit
9495: IF FND_API.To_Boolean(p_commit) THEN
9496: COMMIT WORK;
9497: END IF;
9498:
9589: l_attr_group_id NUMBER;
9590:
9591: BEGIN
9592:
9593: -- Standard start of API savepoint
9594: IF FND_API.To_Boolean(p_commit) THEN
9595: SAVEPOINT Create_Association_PUB;
9596: END IF;
9597:
9621: ,x_msg_count => x_msg_count
9622: ,x_msg_data => x_msg_data
9623: );
9624:
9625: -- Standard check of p_commit
9626: IF FND_API.To_Boolean(p_commit) THEN
9627: COMMIT WORK;
9628: END IF;
9629:
9676: l_object_id NUMBER;
9677:
9678: BEGIN
9679:
9680: -- Standard start of API savepoint
9681: IF FND_API.To_Boolean(p_commit) THEN
9682: SAVEPOINT Create_Association_PUB;
9683: END IF;
9684:
9706: ,x_msg_count => x_msg_count
9707: ,x_msg_data => x_msg_data
9708: );
9709:
9710: -- Standard check of p_commit
9711: IF FND_API.To_Boolean(p_commit) THEN
9712: COMMIT WORK;
9713: END IF;
9714:
9761: l_Sysdate DATE := Sysdate;
9762:
9763: BEGIN
9764:
9765: -- Standard start of API savepoint
9766: IF FND_API.To_Boolean(p_commit) THEN
9767: SAVEPOINT Update_Association_PUB;
9768: END IF;
9769:
9790: LAST_UPDATED_BY = g_current_user_id,
9791: LAST_UPDATE_LOGIN = g_current_login_id
9792: WHERE ASSOCIATION_ID = p_association_id;
9793:
9794: -- Standard check of p_commit
9795: IF FND_API.To_Boolean(p_commit) THEN
9796: COMMIT WORK;
9797: END IF;
9798:
9840: l_association_id NUMBER;
9841:
9842: BEGIN
9843:
9844: -- Standard start of API savepoint
9845: IF FND_API.To_Boolean(p_commit) THEN
9846: SAVEPOINT Update_Association_PUB;
9847: END IF;
9848:
9866: ,x_msg_count => x_msg_count
9867: ,x_msg_data => x_msg_data
9868: );
9869:
9870: -- Standard check of p_commit
9871: IF FND_API.To_Boolean(p_commit) THEN
9872: COMMIT WORK;
9873: END IF;
9874:
9921: l_association_id NUMBER;
9922:
9923: BEGIN
9924:
9925: -- Standard start of API savepoint
9926: IF FND_API.To_Boolean(p_commit) THEN
9927: SAVEPOINT Update_Association_PUB;
9928: END IF;
9929:
9955: ,x_msg_count => x_msg_count
9956: ,x_msg_data => x_msg_data
9957: );
9958:
9959: -- Standard check of p_commit
9960: IF FND_API.To_Boolean(p_commit) THEN
9961: COMMIT WORK;
9962: END IF;
9963:
10035: where association_id = cp_association_id);
10036:
10037: BEGIN
10038: code_debug(l_api_name||' started for association '||p_association_id);
10039: -- Standard start of API savepoint
10040: IF FND_API.To_Boolean(p_commit) THEN
10041: SAVEPOINT Delete_Association_PUB;
10042: END IF;
10043:
10172: END IF; --check p_force
10173:
10174:
10175: IF (l_is_ok_to_delete) THEN
10176: -- Standard check of p_commit
10177: IF FND_API.To_Boolean(p_commit) THEN
10178: COMMIT WORK;
10179: END IF;
10180: x_return_status := FND_API.G_RET_STS_SUCCESS;
10246: l_Sysdate DATE := Sysdate;
10247:
10248: BEGIN
10249:
10250: -- Standard start of API savepoint
10251: IF FND_API.To_Boolean(p_commit) THEN
10252: SAVEPOINT Create_Page_PUB;
10253: END IF;
10254:
10325: ,g_current_login_id
10326: FROM FND_LANGUAGES L
10327: WHERE L.INSTALLED_FLAG in ('I', 'B');
10328:
10329: -- Standard check of p_commit
10330: IF FND_API.To_Boolean(p_commit) THEN
10331: COMMIT WORK;
10332: END IF;
10333:
10379: l_Sysdate DATE := Sysdate;
10380:
10381: BEGIN
10382:
10383: -- Standard start of API savepoint
10384: IF FND_API.To_Boolean(p_commit) THEN
10385: SAVEPOINT Update_Page_PUB;
10386: END IF;
10387:
10427: WHERE PAGE_ID = p_page_id
10428: -- AND LANGUAGE = USERENV('LANG');
10429: AND USERENV('LANG') in ( LANGUAGE , SOURCE_LANG);
10430:
10431: -- Standard check of p_commit
10432: IF FND_API.To_Boolean(p_commit) THEN
10433: COMMIT WORK;
10434: END IF;
10435:
10480: l_new_internal_name VARCHAR2(150);
10481:
10482: BEGIN
10483:
10484: -- Standard start of API savepoint
10485: IF FND_API.To_Boolean(p_commit) THEN
10486: SAVEPOINT Update_Page_PUB;
10487: END IF;
10488:
10514: ,x_msg_count => x_msg_count
10515: ,x_msg_data => x_msg_data
10516: );
10517:
10518: -- Standard check of p_commit
10519: IF FND_API.To_Boolean(p_commit) THEN
10520: COMMIT WORK;
10521: END IF;
10522:
10564: l_api_version CONSTANT NUMBER := 1.0;
10565:
10566: BEGIN
10567:
10568: -- Standard start of API savepoint
10569: IF FND_API.To_Boolean(p_commit) THEN
10570: SAVEPOINT Delete_Page_PUB;
10571: END IF;
10572:
10589:
10590: DELETE FROM EGO_PAGES_TL
10591: WHERE PAGE_ID = p_page_id;
10592:
10593: -- Standard check of p_commit
10594: IF FND_API.To_Boolean(p_commit) THEN
10595: COMMIT WORK;
10596: END IF;
10597:
10636: l_page_id NUMBER;
10637:
10638: BEGIN
10639:
10640: -- Standard start of API savepoint
10641: IF FND_API.To_Boolean(p_commit) THEN
10642: SAVEPOINT Delete_Page_PUB;
10643: END IF;
10644:
10659: ,x_msg_count => x_msg_count
10660: ,x_msg_data => x_msg_data
10661: );
10662:
10663: -- Standard check of p_commit
10664: IF FND_API.To_Boolean(p_commit) THEN
10665: COMMIT WORK;
10666: END IF;
10667:
10773: l_Sysdate DATE := Sysdate;
10774:
10775: BEGIN
10776:
10777: -- Standard start of API savepoint
10778: IF FND_API.To_Boolean(p_commit) THEN
10779: SAVEPOINT Create_Page_Entry_PUB;
10780: END IF;
10781:
10814: ,g_current_user_id
10815: ,g_current_login_id
10816: );
10817:
10818: -- Standard check of p_commit
10819: IF FND_API.To_Boolean(p_commit) THEN
10820: COMMIT WORK;
10821: END IF;
10822:
10916: l_Sysdate DATE := Sysdate;
10917:
10918: BEGIN
10919:
10920: -- Standard start of API savepoint
10921: IF FND_API.To_Boolean(p_commit) THEN
10922: SAVEPOINT Update_Page_Entry_PUB;
10923: END IF;
10924:
10941: LAST_UPDATE_LOGIN = g_current_login_id
10942: WHERE PAGE_ID = p_page_id
10943: AND ASSOCIATION_ID = p_old_association_id;
10944:
10945: -- Standard check of p_commit
10946: IF FND_API.To_Boolean(p_commit) THEN
10947: COMMIT WORK;
10948: END IF;
10949:
11040: l_api_version CONSTANT NUMBER := 1.0;
11041:
11042: BEGIN
11043:
11044: -- Standard start of API savepoint
11045: IF FND_API.To_Boolean(p_commit) THEN
11046: SAVEPOINT Delete_Page_Entry_PUB;
11047: END IF;
11048:
11062: WHERE PAGE_ID = p_page_id
11063: AND ASSOCIATION_ID = p_association_id
11064: AND CLASSIFICATION_CODE = p_classification_code;
11065:
11066: -- Standard check of p_commit
11067: IF FND_API.To_Boolean(p_commit) THEN
11068: COMMIT WORK;
11069: END IF;
11070:
11124: l_Sysdate DATE := Sysdate;
11125:
11126: BEGIN
11127:
11128: -- Standard start of API savepoint
11129: IF FND_API.To_Boolean(p_commit) THEN
11130: SAVEPOINT Create_Function_PUB;
11131: END IF;
11132:
11196: ,g_current_login_id
11197: FROM FND_LANGUAGES L
11198: WHERE L.INSTALLED_FLAG in ('I', 'B');
11199:
11200: -- Standard check of p_commit
11201: IF FND_API.To_Boolean(p_commit) THEN
11202: COMMIT WORK;
11203: END IF;
11204:
11251: l_Sysdate DATE := Sysdate;
11252:
11253: BEGIN
11254:
11255: -- Standard start of API savepoint
11256: IF FND_API.To_Boolean(p_commit) THEN
11257: SAVEPOINT Update_Function_PUB;
11258: END IF;
11259:
11291: WHERE
11292: -- FUNCTION_ID = p_function_id AND LANGUAGE = USERENV('LANG');
11293: FUNCTION_ID = p_function_id AND USERENV('LANG') IN (LANGUAGE ,SOURCE_LANG );
11294:
11295: -- Standard check of p_commit
11296: IF FND_API.To_Boolean(p_commit) THEN
11297: COMMIT WORK;
11298: END IF;
11299:
11343: l_Sysdate DATE := Sysdate;
11344:
11345: BEGIN
11346:
11347: -- Standard start of API savepoint
11348: IF FND_API.To_Boolean(p_commit) THEN
11349: SAVEPOINT Delete_Function_PUB;
11350: END IF;
11351:
11401: DELETE FROM EGO_FUNCTIONS_TL
11402: WHERE
11403: FUNCTION_ID = p_function_id;
11404:
11405: -- Standard check of p_commit
11406: IF FND_API.To_Boolean(p_commit) THEN
11407: COMMIT WORK;
11408: END IF;
11409:
11475: e_dup_action_name_error EXCEPTION;
11476:
11477: BEGIN
11478:
11479: -- Standard start of API savepoint
11480: IF FND_API.To_Boolean(p_commit) THEN
11481: SAVEPOINT Create_Action_PUB;
11482: END IF;
11483:
11585:
11586: FROM FND_LANGUAGES L
11587: WHERE L.INSTALLED_FLAG in ('I', 'B');
11588:
11589: -- Standard check of p_commit
11590: IF FND_API.To_Boolean(p_commit) THEN
11591: COMMIT WORK;
11592: END IF;
11593:
11666: l_attr_group_id NUMBER;
11667:
11668: BEGIN
11669:
11670: -- Standard start of API savepoint
11671: IF FND_API.To_Boolean(p_commit) THEN
11672: SAVEPOINT Create_Action_PUB;
11673: END IF;
11674:
11697: ,x_msg_count => x_msg_count
11698: ,x_msg_data => x_msg_data
11699: );
11700:
11701: -- Standard check of p_commit
11702: IF FND_API.To_Boolean(p_commit) THEN
11703: COMMIT WORK;
11704: END IF;
11705:
11766: e_dup_action_name_error EXCEPTION;
11767:
11768: BEGIN
11769:
11770: -- Standard start of API savepoint
11771: IF FND_API.To_Boolean(p_commit) THEN
11772: SAVEPOINT Update_Action_PUB;
11773: END IF;
11774:
11868: WHERE
11869: -- ACTION_ID = p_action_id AND LANGUAGE = USERENV('LANG');
11870: ACTION_ID = p_action_id AND USERENV('LANG') IN (LANGUAGE , SOURCE_LANG);
11871:
11872: -- Standard check of p_commit
11873: IF FND_API.To_Boolean(p_commit) THEN
11874: COMMIT WORK;
11875: END IF;
11876:
11948:
11949:
11950: BEGIN
11951:
11952: -- Standard start of API savepoint
11953: IF FND_API.To_Boolean(p_commit) THEN
11954: SAVEPOINT Delete_Action_PUB;
11955: END IF;
11956:
12004: IF (l_visibility_count > 0) THEN
12005: Delete_Action_Data_Level(p_api_version,p_action_id,null, null, x_return_status,x_errorcode, x_msg_count, x_msg_data);
12006: END IF;
12007:
12008: -- Standard check of p_commit
12009: IF FND_API.To_Boolean(p_commit) THEN
12010: COMMIT WORK;
12011: END IF;
12012:
12057: l_Sysdate DATE := Sysdate;
12058:
12059: BEGIN
12060:
12061: -- Standard start of API savepoint
12062: IF FND_API.To_Boolean(p_commit) THEN
12063: SAVEPOINT Create_Visibilty_DL_PUB;
12064: END IF;
12065:
12096: ,g_current_user_id
12097: ,g_current_login_id
12098: );
12099:
12100: -- Standard check of p_commit
12101: IF FND_API.To_Boolean(p_commit) THEN
12102: COMMIT WORK;
12103: END IF;
12104:
12152: l_Sysdate DATE := Sysdate;
12153:
12154: BEGIN
12155:
12156: -- Standard start of API savepoint
12157: IF FND_API.To_Boolean(p_commit) THEN
12158: SAVEPOINT Create_Action_Display_PUB;
12159: END IF;
12160:
12201: ,g_current_user_id
12202: ,g_current_login_id
12203: );
12204:
12205: -- Standard check of p_commit
12206: IF FND_API.To_Boolean(p_commit) THEN
12207: COMMIT WORK;
12208: END IF;
12209:
12253: l_Sysdate DATE := Sysdate;
12254:
12255: BEGIN
12256:
12257: -- Standard start of API savepoint
12258: IF FND_API.To_Boolean(p_commit) THEN
12259: SAVEPOINT Create_Action_Display_PUB;
12260: END IF;
12261:
12292: ,g_current_user_id
12293: ,g_current_login_id
12294: );
12295:
12296: -- Standard check of p_commit
12297: IF FND_API.To_Boolean(p_commit) THEN
12298: COMMIT WORK;
12299: END IF;
12300:
12356: l_vis_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'V';
12357:
12358: BEGIN
12359:
12360: -- Standard start of API savepoint
12361: IF FND_API.To_Boolean(p_commit) THEN
12362: SAVEPOINT Update_Action_Display_PUB;
12363: END IF;
12364:
12464: WHERE
12465: ACTION_ID = p_action_id;
12466: END IF;
12467:
12468: -- Standard check of p_commit
12469: IF FND_API.To_Boolean(p_commit) THEN
12470: COMMIT WORK;
12471: END IF;
12472:
12522: l_vis_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'V';
12523:
12524: BEGIN
12525:
12526: -- Standard start of API savepoint
12527: IF FND_API.To_Boolean(p_commit) THEN
12528: SAVEPOINT Update_Action_Display_PUB;
12529: END IF;
12530:
12624: END IF;
12625:
12626: -----------------------------------
12627:
12628: -- Standard check of p_commit
12629: IF FND_API.To_Boolean(p_commit) THEN
12630: COMMIT WORK;
12631: END IF;
12632:
12678: l_vis_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'V';
12679:
12680: BEGIN
12681:
12682: -- Standard start of API savepoint
12683: IF FND_API.To_Boolean(p_commit) THEN
12684: SAVEPOINT Delete_Action_Display_PUB;
12685: END IF;
12686:
12743: null, x_return_status, x_errorcode,
12744: x_msg_count, x_msg_data);
12745: END IF;
12746:
12747: -- Standard check of p_commit
12748: IF FND_API.To_Boolean(p_commit) THEN
12749: COMMIT WORK;
12750: END IF;
12751:
12805: l_Sysdate DATE := Sysdate;
12806:
12807: BEGIN
12808:
12809: -- Standard start of API savepoint
12810: IF FND_API.To_Boolean(p_commit) THEN
12811: SAVEPOINT Create_Function_Param_PUB;
12812: END IF;
12813:
12877: ,g_current_login_id
12878: FROM FND_LANGUAGES L
12879: WHERE L.INSTALLED_FLAG in ('I', 'B');
12880:
12881: -- Standard check of p_commit
12882: IF FND_API.To_Boolean(p_commit) THEN
12883: COMMIT WORK;
12884: END IF;
12885:
12930: l_Sysdate DATE := Sysdate;
12931:
12932: BEGIN
12933:
12934: -- Standard start of API savepoint
12935: IF FND_API.To_Boolean(p_commit) THEN
12936: SAVEPOINT Update_Function_Param_PUB;
12937: END IF;
12938:
12968: FUNC_PARAM_ID = p_function_param_id AND
12969: --userenv('LANG') = LANGUAGE;
12970: USERENV('LANG') IN ( LANGUAGE ,SOURCE_LANG );
12971:
12972: -- Standard check of p_commit
12973: IF FND_API.To_Boolean(p_commit) THEN
12974: COMMIT WORK;
12975: END IF;
12976:
13018: l_Sysdate DATE := Sysdate;
13019:
13020: BEGIN
13021:
13022: -- Standard start of API savepoint
13023: IF FND_API.To_Boolean(p_commit) THEN
13024: SAVEPOINT Delete_Function_Param_PUB;
13025: END IF;
13026:
13046: DELETE FROM EGO_MAPPINGS_B
13047: WHERE
13048: FUNC_PARAM_ID = p_function_param_id;
13049:
13050: -- Standard check of p_commit
13051: IF FND_API.To_Boolean(p_commit) THEN
13052: COMMIT WORK;
13053: END IF;
13054:
13113: l_Sysdate DATE := Sysdate;
13114:
13115: BEGIN
13116:
13117: -- Standard start of API savepoint
13118: IF FND_API.To_Boolean(p_commit) THEN
13119: SAVEPOINT Create_Mapping_PUB;
13120: END IF;
13121:
13170: ,g_current_user_id
13171: ,g_current_login_id
13172: );
13173:
13174: -- Standard check of p_commit
13175: IF FND_API.To_Boolean(p_commit) THEN
13176: COMMIT WORK;
13177: END IF;
13178:
13227: l_mapping_group_type VARCHAR2(30);
13228:
13229: BEGIN
13230:
13231: -- Standard start of API savepoint
13232: IF FND_API.TO_BOOLEAN(p_commit) THEN
13233: SAVEPOINT Create_Mapping_PUB;
13234: END IF;
13235:
13259: ,x_msg_count => x_msg_count
13260: ,x_msg_data => x_msg_data
13261: );
13262:
13263: -- Standard check of p_commit
13264: IF FND_API.To_Boolean(p_commit) THEN
13265: COMMIT WORK;
13266: END IF;
13267:
13327: l_Sysdate DATE := Sysdate;
13328:
13329: BEGIN
13330:
13331: -- Standard start of API savepoint
13332: IF FND_API.To_Boolean(p_commit) THEN
13333: SAVEPOINT Update_Mapping_PUB;
13334: END IF;
13335:
13396: FUNC_PARAM_ID = p_func_param_id;
13397:
13398: END IF;
13399:
13400: -- Standard check of p_commit
13401: IF FND_API.To_Boolean(p_commit) THEN
13402: COMMIT WORK;
13403: END IF;
13404:
13459: l_mapping_group_type VARCHAR2(30);
13460:
13461: BEGIN
13462:
13463: -- Standard start of API savepoint
13464: IF FND_API.TO_BOOLEAN(p_commit) THEN
13465: SAVEPOINT Update_Mapping_PUB;
13466: END IF;
13467:
13498: ,x_msg_count => x_msg_count
13499: ,x_msg_data => x_msg_data
13500: );
13501:
13502: -- Standard check of p_commit
13503: IF FND_API.To_Boolean(p_commit) THEN
13504: COMMIT WORK;
13505: END IF;
13506: EXCEPTION
13550: l_api_version CONSTANT NUMBER := 1.0;
13551:
13552: BEGIN
13553:
13554: -- Standard start of API savepoint
13555: IF FND_API.To_Boolean(p_commit) THEN
13556: SAVEPOINT Update_Mapping_PUB;
13557: END IF;
13558:
13572: FUNCTION_ID = p_function_id AND
13573: MAPPED_OBJ_TYPE = p_mapped_obj_type AND
13574: MAPPED_OBJ_PK1_VAL = p_mapped_obj_pk1_value;
13575:
13576: -- Standard check of p_commit
13577: IF FND_API.To_Boolean(p_commit) THEN
13578: COMMIT WORK;
13579: END IF;
13580:
13624: l_api_version CONSTANT NUMBER := 1.0;
13625:
13626: BEGIN
13627:
13628: -- Standard start of API savepoint
13629: IF FND_API.To_Boolean(p_commit) THEN
13630: SAVEPOINT Delete_Func_Param_Mapping_PUB;
13631: END IF;
13632:
13647: MAPPED_OBJ_TYPE = p_mapped_obj_type AND
13648: MAPPED_OBJ_PK1_VAL = p_mapped_obj_pk1_value AND
13649: FUNC_PARAM_ID = p_func_param_id;
13650:
13651: -- Standard check of p_commit
13652: IF FND_API.To_Boolean(p_commit) THEN
13653: COMMIT WORK;
13654: END IF;
13655:
13709: l_Sysdate DATE := Sysdate;
13710:
13711: BEGIN
13712:
13713: -- Standard start of API savepoint
13714: IF FND_API.To_Boolean(p_commit) THEN
13715: SAVEPOINT Create_Action_Group_PUB;
13716: END IF;
13717:
13782:
13783: FROM FND_LANGUAGES L
13784: WHERE L.INSTALLED_FLAG in ('I', 'B');
13785:
13786: -- Standard check of p_commit
13787: IF FND_API.To_Boolean(p_commit) THEN
13788: COMMIT WORK;
13789: END IF;
13790:
13836: l_Sysdate DATE := Sysdate;
13837:
13838: BEGIN
13839:
13840: -- Standard start of API savepoint
13841: IF FND_API.To_Boolean(p_commit) THEN
13842: SAVEPOINT Update_Action_Group_PUB;
13843: END IF;
13844:
13876: WHERE
13877: -- ACTION_GROUP_ID = p_action_group_id AND LANGUAGE = USERENV('LANG');
13878: ACTION_GROUP_ID = p_action_group_id AND USERENV('LANG') IN (LANGUAGE , SOURCE_LANG);
13879:
13880: -- Standard check of p_commit
13881: IF FND_API.To_Boolean(p_commit) THEN
13882: COMMIT WORK;
13883: END IF;
13884:
13924: l_api_version CONSTANT NUMBER := 1.0;
13925:
13926: BEGIN
13927:
13928: -- Standard start of API savepoint
13929: IF FND_API.To_Boolean(p_commit) THEN
13930: SAVEPOINT Delete_Action_Group_PUB;
13931: END IF;
13932:
13954: DELETE FROM EGO_ACTION_GROUPS_TL
13955: WHERE
13956: ACTION_GROUP_ID = p_action_group_id;
13957:
13958: -- Standard check of p_commit
13959: IF FND_API.To_Boolean(p_commit) THEN
13960: COMMIT WORK;
13961: END IF;
13962:
14013: l_exist_action_count NUMBER := 0;
14014:
14015: BEGIN
14016:
14017: -- Standard start of API savepoint
14018: IF FND_API.To_Boolean(p_commit) THEN
14019: SAVEPOINT Create_Action_Group_Entry_PUB;
14020: END IF;
14021:
14060: ,g_current_login_id
14061: );
14062: END IF;
14063:
14064: -- Standard check of p_commit
14065: IF FND_API.To_Boolean(p_commit) THEN
14066: COMMIT WORK;
14067: END IF;
14068:
14113: l_exist_action_count NUMBER := 0;
14114:
14115: BEGIN
14116:
14117: -- Standard start of API savepoint
14118: IF FND_API.To_Boolean(p_commit) THEN
14119: SAVEPOINT Update_Action_Group_Entry_PUB;
14120: END IF;
14121:
14134: SET SEQUENCE = p_sequence
14135: WHERE ACTION_GROUP_ID = p_action_group_id
14136: AND ACTION_ID = p_action_id;
14137:
14138: -- Standard check of p_commit
14139: IF FND_API.To_Boolean(p_commit) THEN
14140: COMMIT WORK;
14141: END IF;
14142:
14183: l_api_version CONSTANT NUMBER := 1.0;
14184:
14185: BEGIN
14186:
14187: -- Standard start of API savepoint
14188: IF FND_API.To_Boolean(p_commit) THEN
14189: SAVEPOINT Update_Action_Group_Entry_PUB;
14190: END IF;
14191:
14204: WHERE
14205: ACTION_GROUP_ID = p_action_group_id AND
14206: ACTION_ID = p_action_id;
14207:
14208: -- Standard check of p_commit
14209: IF FND_API.To_Boolean(p_commit) THEN
14210: COMMIT WORK;
14211: END IF;
14212:
14837: l_agv_name ego_fnd_dsc_flx_ctx_ext.agv_name%TYPE;
14838: l_temp_agv_name ego_fnd_dsc_flx_ctx_ext.agv_name%TYPE;
14839:
14840: BEGIN
14841: -- Standard Start of API savepoint
14842: IF FND_API.To_Boolean( p_commit ) THEN
14843: SAVEPOINT Update_AGV_Name ;
14844: END IF;
14845: -- Check for call compatibility.
15050: END IF;
15051:
15052:
15053:
15054: -- Standard check of p_commit
15055: IF FND_API.To_Boolean(p_commit) THEN
15056: COMMIT WORK;
15057: END IF;
15058: