[Home] [Help]
224: l_api_version CONSTANT NUMBER := 1.0;
225:
226: BEGIN
227: code_debug ( l_api_name || ' Start ');
228: -- Standard start of API savepoint
229: IF FND_API.To_Boolean(p_commit) THEN
230: SAVEPOINT Delete_Action_Data_Level;
231: END IF;
232:
243:
244: DELETE FROM EGO_ACTIONS_DL
245: WHERE ACTION_ID = p_action_id;
246:
247: -- Standard check of p_commit
248: IF FND_API.To_Boolean(p_commit) THEN
249: COMMIT WORK;
250: END IF;
251: x_return_status := FND_API.G_RET_STS_SUCCESS;
886: l_app_col_name VARCHAR2(30);
887:
888: BEGIN
889:
890: -- Standard start of API savepoint
891: IF FND_API.TO_BOOLEAN(p_commit) THEN
892: SAVEPOINT Delete_Attribute_PRV;
893: END IF;
894:
917: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
918: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name
919: AND APPLICATION_COLUMN_NAME = l_app_col_name;
920:
921: -- Standard check of p_commit
922: IF FND_API.To_Boolean(p_commit) THEN
923: COMMIT WORK;
924: END IF;
925:
966: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name;
967:
968: BEGIN
969:
970: -- Standard start of API savepoint
971: IF FND_API.TO_BOOLEAN(p_commit) THEN
972: SAVEPOINT Delete_Attribute_Group_PVT;
973: END IF;
974:
1001: WHERE APPLICATION_ID = p_application_id
1002: AND ATTR_GROUP_TYPE = p_attr_group_type
1003: AND ATTR_GROUP_NAME = p_attr_group_name);
1004:
1005: -- Standard check of p_commit
1006: IF FND_API.To_Boolean(p_commit) THEN
1007: COMMIT WORK;
1008: END IF;
1009:
2229:
2230:
2231: BEGIN
2232:
2233: -- Standard start of API savepoint
2234: IF FND_API.To_Boolean(p_commit) THEN
2235: SAVEPOINT Create_Attribute_Group_PUB;
2236: END IF;
2237:
2488:
2489: EXECUTE IMMEDIATE l_dynamic_sql;
2490: END IF;
2491: END IF;
2492: -- Standard check of p_commit
2493: IF FND_API.To_Boolean(p_commit) THEN
2494: COMMIT WORK;
2495: END IF;
2496: x_return_status := FND_API.G_RET_STS_SUCCESS;
2691: l_sequence_numbers VARCHAR2(10000);
2692:
2693: BEGIN
2694:
2695: -- Standard start of API savepoint
2696: IF FND_API.TO_BOOLEAN(p_commit) THEN
2697: SAVEPOINT Copy_Attribute_Group_PUB;
2698: END IF;
2699:
2766: );
2767: END LOOP;
2768: CLOSE ego_attribute_csr;
2769:
2770: -- Standard check of p_commit
2771: IF FND_API.To_Boolean(p_commit) THEN
2772: COMMIT WORK;
2773: END IF;
2774:
2912: l_attr_group_pks EGO_VARCHAR_TBL_TYPE;
2913:
2914: BEGIN
2915:
2916: -- Standard start of API savepoint
2917: IF FND_API.TO_BOOLEAN(p_commit) THEN
2918: SAVEPOINT Update_Attribute_Group_PUB;
2919: END IF;
2920:
2948: ,x_msg_count => x_msg_count
2949: ,x_msg_data => x_msg_data
2950: );
2951:
2952: -- Standard check of p_commit
2953: IF FND_API.To_Boolean(p_commit) THEN
2954: COMMIT WORK;
2955: END IF;
2956:
3019:
3020:
3021: BEGIN
3022:
3023: -- Standard start of API savepoint
3024: IF FND_API.TO_BOOLEAN(p_commit) THEN
3025: SAVEPOINT Update_Attribute_Group_PUB;
3026: END IF;
3027:
3101: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_internal_name
3102: -- AND LANGUAGE = USERENV('LANG');
3103: AND USERENV('LANG') in (LANGUAGE , SOURCE_LANG);
3104:
3105: -- Standard check of p_commit
3106: IF FND_API.To_Boolean(p_commit) THEN
3107: COMMIT WORK;
3108: END IF;
3109:
3143: l_attr_group_pks EGO_VARCHAR_TBL_TYPE;
3144:
3145: BEGIN
3146:
3147: -- Standard start of API savepoint
3148: IF FND_API.TO_BOOLEAN(p_commit) THEN
3149: SAVEPOINT Delete_Attribute_Group_PUB;
3150: END IF;
3151:
3166: ,x_msg_count => x_msg_count
3167: ,x_msg_data => x_msg_data
3168: );
3169:
3170: -- Standard check of p_commit
3171: IF FND_API.To_Boolean(p_commit) THEN
3172: COMMIT WORK;
3173: END IF;
3174:
3221: l_attr_group_disp_name VARCHAR2(80);
3222:
3223: BEGIN
3224:
3225: -- Standard start of API savepoint
3226: IF FND_API.TO_BOOLEAN(p_commit) THEN
3227: SAVEPOINT Delete_Attribute_Group_PUB;
3228: END IF;
3229:
3274: ,x_msg_data);
3275:
3276: END IF;
3277:
3278: -- Standard check of p_commit
3279: IF FND_API.To_Boolean(p_commit) THEN
3280: COMMIT WORK;
3281: END IF;
3282:
3330: l_ext_table_name FND_DESCRIPTIVE_FLEXS.APPLICATION_TABLE_NAME%TYPE;
3331:
3332: BEGIN
3333:
3334: -- Standard start of API savepoint
3335: IF FND_API.TO_BOOLEAN(p_commit) THEN
3336: SAVEPOINT Compile_Attr_Group_View_PUB;
3337: END IF;
3338:
3695: END IF;
3696: END IF;
3697: END IF;
3698:
3699: -- Standard check of p_commit
3700: IF FND_API.To_Boolean(p_commit) THEN
3701: COMMIT WORK;
3702: END IF;
3703:
4187: THEN
4188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4189: END IF;
4190:
4191: -- Standard start of API savepoint
4192: IF FND_API.TO_BOOLEAN(p_commit) THEN
4193: SAVEPOINT SYNC_DATA_LEVEL;
4194: END IF;
4195:
4466: THEN
4467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4468: END IF;
4469:
4470: -- Standard start of API savepoint
4471: IF FND_API.TO_BOOLEAN(p_commit) THEN
4472: SAVEPOINT SYNC_DL_ASSOC;
4473: END IF;
4474:
4888:
4889:
4890: BEGIN
4891:
4892: -- Standard start of API savepoint
4893: IF FND_API.TO_BOOLEAN(p_commit) THEN
4894: SAVEPOINT Create_Attribute_PUB;
4895: END IF;
4896:
5422: ,p_lud -- LAST_UPDATE_DATE
5423: ,g_current_login_id -- LAST_UPDATE_LOGIN
5424: FROM DUAL;
5425:
5426: -- Standard check of p_commit
5427: IF FND_API.To_Boolean(p_commit) THEN
5428: COMMIT WORK;
5429: END IF;
5430: x_return_status := FND_API.G_RET_STS_SUCCESS;
5678: e_default_value_len_err EXCEPTION;
5679:
5680:
5681: BEGIN
5682: -- Standard start of API savepoint
5683: IF FND_API.To_Boolean(p_commit) THEN
5684: SAVEPOINT Update_Attribute_PUB;
5685: END IF;
5686:
6001: AND APPLICATION_COLUMN_NAME = p_column
6002: --AND LANGUAGE = USERENV('LANG');
6003: AND USERENV('LANG') in (LANGUAGE , SOURCE_LANG);
6004:
6005: -- Standard check of p_commit
6006: IF FND_API.To_Boolean(p_commit) THEN
6007: COMMIT WORK;
6008: END IF;
6009:
6221: code_debug(' Started '||l_api_name ||' with params ');
6222: code_debug('p_value_set_name - '|| p_value_set_name||' p_description - '||p_description);
6223: code_debug('p_maximum_size - '|| p_maximum_size||' p_maximum_value - '||p_maximum_value||' p_minimum_value - '||p_minimum_value);
6224: code_debug('p_format_code - '|| p_format_code||' p_validation_code - '||p_validation_code||' p_long_list_flag - '||p_long_list_flag);
6225: -- Standard start of API savepoint
6226: IF FND_API.To_Boolean(p_commit) THEN
6227: SAVEPOINT Create_Value_Set_PUB;
6228: END IF;
6229:
6413: INTO x_value_set_id
6414: FROM fnd_flex_value_sets
6415: WHERE flex_value_set_name = p_value_set_name;
6416:
6417: -- Standard check of p_commit
6418: IF FND_API.To_Boolean(p_commit) THEN
6419: COMMIT WORK;
6420: END IF;
6421:
6507: ' p_value_set_name - ' || p_value_set_name ||
6508: ' p_description - ' || p_description ||
6509: ' p_parent_vs_id - ' || p_parent_vs_id );
6510:
6511: -- Standard start of API savepoint
6512: IF FND_API.To_Boolean(p_commit) THEN
6513: SAVEPOINT Create_Child_Value_Set_PUB;
6514: END IF;
6515:
6826: l_api_name := 'Update_Value_Set';
6827: l_api_version := 1.0;
6828: l_Sysdate := SYSDATE;
6829:
6830: -- Standard start of API savepoint
6831: IF FND_API.To_Boolean(p_commit) THEN
6832: SAVEPOINT Update_Value_Set_PUB;
6833: END IF;
6834:
6944: -- dbms_output.put_line(' ' || l_value_set_rec.value_set_id);
6945: END LOOP child_value_set_ids_loop;
6946:
6947:
6948: -- Standard check of p_commit
6949: IF FND_API.To_Boolean(p_commit) THEN
6950: COMMIT WORK;
6951: END IF;
6952:
7024: ' with params:' ||
7025: ' p_value_set_id - ' || p_value_set_id ||
7026: ' p_description - ' || p_description );
7027:
7028: -- Standard start of API savepoint
7029: IF FND_API.To_Boolean(p_commit) THEN
7030: SAVEPOINT Update_Child_Value_Set_PUB;
7031: END IF;
7032:
7204: l_api_version := 1.0;
7205: l_Sysdate := SYSDATE;
7206: code_debug(l_api_name ||' start ');
7207:
7208: -- Standard start of API savepoint
7209: IF FND_API.To_Boolean(p_commit) THEN
7210: SAVEPOINT Insert_Value_Set_Table_Inf_PUB;
7211: END IF;
7212:
7306: ,g_current_login_id --LAST_UPDATE_LOGIN
7307: );
7308:
7309: code_debug(l_api_name ||' inserting data into fnd_flex_validation_tables COMPLETED ');
7310: -- Standard check of p_commit
7311: IF FND_API.To_Boolean(p_commit) THEN
7312: COMMIT WORK;
7313: END IF;
7314:
7383: l_api_version := 1.0;
7384: l_Sysdate := SYSDATE;
7385:
7386: code_debug(l_api_name ||' start ');
7387: -- Standard start of API savepoint
7388: IF FND_API.To_Boolean(p_commit) THEN
7389: SAVEPOINT Update_Value_Set_Table_Inf_PUB;
7390: END IF;
7391:
7449: LAST_UPDATE_LOGIN = g_current_login_id
7450: WHERE FLEX_VALUE_SET_ID = p_value_set_id;
7451:
7452: code_debug(l_api_name ||' calling update fnd_flex_validation_tables COMPLETED ');
7453: -- Standard check of p_commit
7454: IF FND_API.To_Boolean(p_commit) THEN
7455: COMMIT WORK;
7456: END IF;
7457:
7527:
7528: l_api_name := 'Create_Value_Set_Val';
7529: l_api_version := 1.0;
7530:
7531: -- Standard start of API savepoint
7532: IF FND_API.To_Boolean(p_commit) THEN
7533: SAVEPOINT Create_Value_Set_Val_PUB;
7534: END IF;
7535:
7644: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7645: RAISE FND_API.G_EXC_ERROR;
7646: END IF;
7647:
7648: -- Standard check of p_commit
7649: IF FND_API.To_Boolean(p_commit) THEN
7650: COMMIT WORK;
7651: END IF;
7652:
7712:
7713: l_api_name := 'Update_Value_Set_Val';
7714: l_api_version := 1.0;
7715:
7716: -- Standard start of API savepoint
7717: IF FND_API.To_Boolean(p_commit) THEN
7718: SAVEPOINT Update_Value_Set_Val_PUB;
7719: END IF;
7720:
7771: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7772: RAISE FND_API.G_EXC_ERROR;
7773: END IF;
7774:
7775: -- Standard check of p_commit
7776: IF FND_API.To_Boolean(p_commit) THEN
7777: COMMIT WORK;
7778: END IF;
7779:
8153: END IF;
8154:
8155: code_debug(l_api_name||' msg pub initialized ' );
8156: --
8157: --Standard checks
8158: --
8159: IF NOT FND_API.Compatible_API_Call (l_api_version
8160: ,p_api_version
8161: ,l_api_name
8348:
8349:
8350: BEGIN
8351:
8352: -- Standard start of API savepoint
8353: IF FND_API.To_Boolean(p_commit) THEN
8354: SAVEPOINT Create_Association_PUB;
8355: END IF;
8356:
8522: CLOSE data_level_merge;
8523:
8524: END IF;
8525:
8526: -- Standard check of p_commit
8527: IF FND_API.To_Boolean(p_commit) THEN
8528: COMMIT WORK;
8529: END IF;
8530:
8619: l_attr_group_id NUMBER;
8620:
8621: BEGIN
8622:
8623: -- Standard start of API savepoint
8624: IF FND_API.To_Boolean(p_commit) THEN
8625: SAVEPOINT Create_Association_PUB;
8626: END IF;
8627:
8651: ,x_msg_count => x_msg_count
8652: ,x_msg_data => x_msg_data
8653: );
8654:
8655: -- Standard check of p_commit
8656: IF FND_API.To_Boolean(p_commit) THEN
8657: COMMIT WORK;
8658: END IF;
8659:
8706: l_object_id NUMBER;
8707:
8708: BEGIN
8709:
8710: -- Standard start of API savepoint
8711: IF FND_API.To_Boolean(p_commit) THEN
8712: SAVEPOINT Create_Association_PUB;
8713: END IF;
8714:
8736: ,x_msg_count => x_msg_count
8737: ,x_msg_data => x_msg_data
8738: );
8739:
8740: -- Standard check of p_commit
8741: IF FND_API.To_Boolean(p_commit) THEN
8742: COMMIT WORK;
8743: END IF;
8744:
8791: l_Sysdate DATE := Sysdate;
8792:
8793: BEGIN
8794:
8795: -- Standard start of API savepoint
8796: IF FND_API.To_Boolean(p_commit) THEN
8797: SAVEPOINT Update_Association_PUB;
8798: END IF;
8799:
8820: LAST_UPDATED_BY = g_current_user_id,
8821: LAST_UPDATE_LOGIN = g_current_login_id
8822: WHERE ASSOCIATION_ID = p_association_id;
8823:
8824: -- Standard check of p_commit
8825: IF FND_API.To_Boolean(p_commit) THEN
8826: COMMIT WORK;
8827: END IF;
8828:
8870: l_association_id NUMBER;
8871:
8872: BEGIN
8873:
8874: -- Standard start of API savepoint
8875: IF FND_API.To_Boolean(p_commit) THEN
8876: SAVEPOINT Update_Association_PUB;
8877: END IF;
8878:
8896: ,x_msg_count => x_msg_count
8897: ,x_msg_data => x_msg_data
8898: );
8899:
8900: -- Standard check of p_commit
8901: IF FND_API.To_Boolean(p_commit) THEN
8902: COMMIT WORK;
8903: END IF;
8904:
8951: l_association_id NUMBER;
8952:
8953: BEGIN
8954:
8955: -- Standard start of API savepoint
8956: IF FND_API.To_Boolean(p_commit) THEN
8957: SAVEPOINT Update_Association_PUB;
8958: END IF;
8959:
8985: ,x_msg_count => x_msg_count
8986: ,x_msg_data => x_msg_data
8987: );
8988:
8989: -- Standard check of p_commit
8990: IF FND_API.To_Boolean(p_commit) THEN
8991: COMMIT WORK;
8992: END IF;
8993:
9065: where association_id = cp_association_id);
9066:
9067: BEGIN
9068: code_debug(l_api_name||' started for association '||p_association_id);
9069: -- Standard start of API savepoint
9070: IF FND_API.To_Boolean(p_commit) THEN
9071: SAVEPOINT Delete_Association_PUB;
9072: END IF;
9073:
9202: END IF; --check p_force
9203:
9204:
9205: IF (l_is_ok_to_delete) THEN
9206: -- Standard check of p_commit
9207: IF FND_API.To_Boolean(p_commit) THEN
9208: COMMIT WORK;
9209: END IF;
9210: x_return_status := FND_API.G_RET_STS_SUCCESS;
9276: l_Sysdate DATE := Sysdate;
9277:
9278: BEGIN
9279:
9280: -- Standard start of API savepoint
9281: IF FND_API.To_Boolean(p_commit) THEN
9282: SAVEPOINT Create_Page_PUB;
9283: END IF;
9284:
9355: ,g_current_login_id
9356: FROM FND_LANGUAGES L
9357: WHERE L.INSTALLED_FLAG in ('I', 'B');
9358:
9359: -- Standard check of p_commit
9360: IF FND_API.To_Boolean(p_commit) THEN
9361: COMMIT WORK;
9362: END IF;
9363:
9409: l_Sysdate DATE := Sysdate;
9410:
9411: BEGIN
9412:
9413: -- Standard start of API savepoint
9414: IF FND_API.To_Boolean(p_commit) THEN
9415: SAVEPOINT Update_Page_PUB;
9416: END IF;
9417:
9457: WHERE PAGE_ID = p_page_id
9458: -- AND LANGUAGE = USERENV('LANG');
9459: AND USERENV('LANG') in ( LANGUAGE , SOURCE_LANG);
9460:
9461: -- Standard check of p_commit
9462: IF FND_API.To_Boolean(p_commit) THEN
9463: COMMIT WORK;
9464: END IF;
9465:
9510: l_new_internal_name VARCHAR2(150);
9511:
9512: BEGIN
9513:
9514: -- Standard start of API savepoint
9515: IF FND_API.To_Boolean(p_commit) THEN
9516: SAVEPOINT Update_Page_PUB;
9517: END IF;
9518:
9544: ,x_msg_count => x_msg_count
9545: ,x_msg_data => x_msg_data
9546: );
9547:
9548: -- Standard check of p_commit
9549: IF FND_API.To_Boolean(p_commit) THEN
9550: COMMIT WORK;
9551: END IF;
9552:
9594: l_api_version CONSTANT NUMBER := 1.0;
9595:
9596: BEGIN
9597:
9598: -- Standard start of API savepoint
9599: IF FND_API.To_Boolean(p_commit) THEN
9600: SAVEPOINT Delete_Page_PUB;
9601: END IF;
9602:
9619:
9620: DELETE FROM EGO_PAGES_TL
9621: WHERE PAGE_ID = p_page_id;
9622:
9623: -- Standard check of p_commit
9624: IF FND_API.To_Boolean(p_commit) THEN
9625: COMMIT WORK;
9626: END IF;
9627:
9666: l_page_id NUMBER;
9667:
9668: BEGIN
9669:
9670: -- Standard start of API savepoint
9671: IF FND_API.To_Boolean(p_commit) THEN
9672: SAVEPOINT Delete_Page_PUB;
9673: END IF;
9674:
9689: ,x_msg_count => x_msg_count
9690: ,x_msg_data => x_msg_data
9691: );
9692:
9693: -- Standard check of p_commit
9694: IF FND_API.To_Boolean(p_commit) THEN
9695: COMMIT WORK;
9696: END IF;
9697:
9803: l_Sysdate DATE := Sysdate;
9804:
9805: BEGIN
9806:
9807: -- Standard start of API savepoint
9808: IF FND_API.To_Boolean(p_commit) THEN
9809: SAVEPOINT Create_Page_Entry_PUB;
9810: END IF;
9811:
9844: ,g_current_user_id
9845: ,g_current_login_id
9846: );
9847:
9848: -- Standard check of p_commit
9849: IF FND_API.To_Boolean(p_commit) THEN
9850: COMMIT WORK;
9851: END IF;
9852:
9946: l_Sysdate DATE := Sysdate;
9947:
9948: BEGIN
9949:
9950: -- Standard start of API savepoint
9951: IF FND_API.To_Boolean(p_commit) THEN
9952: SAVEPOINT Update_Page_Entry_PUB;
9953: END IF;
9954:
9971: LAST_UPDATE_LOGIN = g_current_login_id
9972: WHERE PAGE_ID = p_page_id
9973: AND ASSOCIATION_ID = p_old_association_id;
9974:
9975: -- Standard check of p_commit
9976: IF FND_API.To_Boolean(p_commit) THEN
9977: COMMIT WORK;
9978: END IF;
9979:
10070: l_api_version CONSTANT NUMBER := 1.0;
10071:
10072: BEGIN
10073:
10074: -- Standard start of API savepoint
10075: IF FND_API.To_Boolean(p_commit) THEN
10076: SAVEPOINT Delete_Page_Entry_PUB;
10077: END IF;
10078:
10092: WHERE PAGE_ID = p_page_id
10093: AND ASSOCIATION_ID = p_association_id
10094: AND CLASSIFICATION_CODE = p_classification_code;
10095:
10096: -- Standard check of p_commit
10097: IF FND_API.To_Boolean(p_commit) THEN
10098: COMMIT WORK;
10099: END IF;
10100:
10154: l_Sysdate DATE := Sysdate;
10155:
10156: BEGIN
10157:
10158: -- Standard start of API savepoint
10159: IF FND_API.To_Boolean(p_commit) THEN
10160: SAVEPOINT Create_Function_PUB;
10161: END IF;
10162:
10226: ,g_current_login_id
10227: FROM FND_LANGUAGES L
10228: WHERE L.INSTALLED_FLAG in ('I', 'B');
10229:
10230: -- Standard check of p_commit
10231: IF FND_API.To_Boolean(p_commit) THEN
10232: COMMIT WORK;
10233: END IF;
10234:
10281: l_Sysdate DATE := Sysdate;
10282:
10283: BEGIN
10284:
10285: -- Standard start of API savepoint
10286: IF FND_API.To_Boolean(p_commit) THEN
10287: SAVEPOINT Update_Function_PUB;
10288: END IF;
10289:
10321: WHERE
10322: -- FUNCTION_ID = p_function_id AND LANGUAGE = USERENV('LANG');
10323: FUNCTION_ID = p_function_id AND USERENV('LANG') IN (LANGUAGE ,SOURCE_LANG );
10324:
10325: -- Standard check of p_commit
10326: IF FND_API.To_Boolean(p_commit) THEN
10327: COMMIT WORK;
10328: END IF;
10329:
10373: l_Sysdate DATE := Sysdate;
10374:
10375: BEGIN
10376:
10377: -- Standard start of API savepoint
10378: IF FND_API.To_Boolean(p_commit) THEN
10379: SAVEPOINT Delete_Function_PUB;
10380: END IF;
10381:
10431: DELETE FROM EGO_FUNCTIONS_TL
10432: WHERE
10433: FUNCTION_ID = p_function_id;
10434:
10435: -- Standard check of p_commit
10436: IF FND_API.To_Boolean(p_commit) THEN
10437: COMMIT WORK;
10438: END IF;
10439:
10505: e_dup_action_name_error EXCEPTION;
10506:
10507: BEGIN
10508:
10509: -- Standard start of API savepoint
10510: IF FND_API.To_Boolean(p_commit) THEN
10511: SAVEPOINT Create_Action_PUB;
10512: END IF;
10513:
10615:
10616: FROM FND_LANGUAGES L
10617: WHERE L.INSTALLED_FLAG in ('I', 'B');
10618:
10619: -- Standard check of p_commit
10620: IF FND_API.To_Boolean(p_commit) THEN
10621: COMMIT WORK;
10622: END IF;
10623:
10696: l_attr_group_id NUMBER;
10697:
10698: BEGIN
10699:
10700: -- Standard start of API savepoint
10701: IF FND_API.To_Boolean(p_commit) THEN
10702: SAVEPOINT Create_Action_PUB;
10703: END IF;
10704:
10727: ,x_msg_count => x_msg_count
10728: ,x_msg_data => x_msg_data
10729: );
10730:
10731: -- Standard check of p_commit
10732: IF FND_API.To_Boolean(p_commit) THEN
10733: COMMIT WORK;
10734: END IF;
10735:
10796: e_dup_action_name_error EXCEPTION;
10797:
10798: BEGIN
10799:
10800: -- Standard start of API savepoint
10801: IF FND_API.To_Boolean(p_commit) THEN
10802: SAVEPOINT Update_Action_PUB;
10803: END IF;
10804:
10898: WHERE
10899: -- ACTION_ID = p_action_id AND LANGUAGE = USERENV('LANG');
10900: ACTION_ID = p_action_id AND USERENV('LANG') IN (LANGUAGE , SOURCE_LANG);
10901:
10902: -- Standard check of p_commit
10903: IF FND_API.To_Boolean(p_commit) THEN
10904: COMMIT WORK;
10905: END IF;
10906:
10978:
10979:
10980: BEGIN
10981:
10982: -- Standard start of API savepoint
10983: IF FND_API.To_Boolean(p_commit) THEN
10984: SAVEPOINT Delete_Action_PUB;
10985: END IF;
10986:
11034: IF (l_visibility_count > 0) THEN
11035: Delete_Action_Data_Level(p_api_version,p_action_id,null, null, x_return_status,x_errorcode, x_msg_count, x_msg_data);
11036: END IF;
11037:
11038: -- Standard check of p_commit
11039: IF FND_API.To_Boolean(p_commit) THEN
11040: COMMIT WORK;
11041: END IF;
11042:
11087: l_Sysdate DATE := Sysdate;
11088:
11089: BEGIN
11090:
11091: -- Standard start of API savepoint
11092: IF FND_API.To_Boolean(p_commit) THEN
11093: SAVEPOINT Create_Visibilty_DL_PUB;
11094: END IF;
11095:
11126: ,g_current_user_id
11127: ,g_current_login_id
11128: );
11129:
11130: -- Standard check of p_commit
11131: IF FND_API.To_Boolean(p_commit) THEN
11132: COMMIT WORK;
11133: END IF;
11134:
11181: l_Sysdate DATE := Sysdate;
11182:
11183: BEGIN
11184:
11185: -- Standard start of API savepoint
11186: IF FND_API.To_Boolean(p_commit) THEN
11187: SAVEPOINT Create_Action_Display_PUB;
11188: END IF;
11189:
11230: ,g_current_user_id
11231: ,g_current_login_id
11232: );
11233:
11234: -- Standard check of p_commit
11235: IF FND_API.To_Boolean(p_commit) THEN
11236: COMMIT WORK;
11237: END IF;
11238:
11282: l_Sysdate DATE := Sysdate;
11283:
11284: BEGIN
11285:
11286: -- Standard start of API savepoint
11287: IF FND_API.To_Boolean(p_commit) THEN
11288: SAVEPOINT Create_Action_Display_PUB;
11289: END IF;
11290:
11321: ,g_current_user_id
11322: ,g_current_login_id
11323: );
11324:
11325: -- Standard check of p_commit
11326: IF FND_API.To_Boolean(p_commit) THEN
11327: COMMIT WORK;
11328: END IF;
11329:
11384: l_vis_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'V';
11385:
11386: BEGIN
11387:
11388: -- Standard start of API savepoint
11389: IF FND_API.To_Boolean(p_commit) THEN
11390: SAVEPOINT Update_Action_Display_PUB;
11391: END IF;
11392:
11492: WHERE
11493: ACTION_ID = p_action_id;
11494: END IF;
11495:
11496: -- Standard check of p_commit
11497: IF FND_API.To_Boolean(p_commit) THEN
11498: COMMIT WORK;
11499: END IF;
11500:
11550: l_vis_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'V';
11551:
11552: BEGIN
11553:
11554: -- Standard start of API savepoint
11555: IF FND_API.To_Boolean(p_commit) THEN
11556: SAVEPOINT Update_Action_Display_PUB;
11557: END IF;
11558:
11652: END IF;
11653:
11654: -----------------------------------
11655:
11656: -- Standard check of p_commit
11657: IF FND_API.To_Boolean(p_commit) THEN
11658: COMMIT WORK;
11659: END IF;
11660:
11706: l_vis_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'V';
11707:
11708: BEGIN
11709:
11710: -- Standard start of API savepoint
11711: IF FND_API.To_Boolean(p_commit) THEN
11712: SAVEPOINT Delete_Action_Display_PUB;
11713: END IF;
11714:
11771: null, x_return_status, x_errorcode,
11772: x_msg_count, x_msg_data);
11773: END IF;
11774:
11775: -- Standard check of p_commit
11776: IF FND_API.To_Boolean(p_commit) THEN
11777: COMMIT WORK;
11778: END IF;
11779:
11833: l_Sysdate DATE := Sysdate;
11834:
11835: BEGIN
11836:
11837: -- Standard start of API savepoint
11838: IF FND_API.To_Boolean(p_commit) THEN
11839: SAVEPOINT Create_Function_Param_PUB;
11840: END IF;
11841:
11905: ,g_current_login_id
11906: FROM FND_LANGUAGES L
11907: WHERE L.INSTALLED_FLAG in ('I', 'B');
11908:
11909: -- Standard check of p_commit
11910: IF FND_API.To_Boolean(p_commit) THEN
11911: COMMIT WORK;
11912: END IF;
11913:
11958: l_Sysdate DATE := Sysdate;
11959:
11960: BEGIN
11961:
11962: -- Standard start of API savepoint
11963: IF FND_API.To_Boolean(p_commit) THEN
11964: SAVEPOINT Update_Function_Param_PUB;
11965: END IF;
11966:
11996: FUNC_PARAM_ID = p_function_param_id AND
11997: --userenv('LANG') = LANGUAGE;
11998: USERENV('LANG') IN ( LANGUAGE ,SOURCE_LANG );
11999:
12000: -- Standard check of p_commit
12001: IF FND_API.To_Boolean(p_commit) THEN
12002: COMMIT WORK;
12003: END IF;
12004:
12046: l_Sysdate DATE := Sysdate;
12047:
12048: BEGIN
12049:
12050: -- Standard start of API savepoint
12051: IF FND_API.To_Boolean(p_commit) THEN
12052: SAVEPOINT Delete_Function_Param_PUB;
12053: END IF;
12054:
12074: DELETE FROM EGO_MAPPINGS_B
12075: WHERE
12076: FUNC_PARAM_ID = p_function_param_id;
12077:
12078: -- Standard check of p_commit
12079: IF FND_API.To_Boolean(p_commit) THEN
12080: COMMIT WORK;
12081: END IF;
12082:
12141: l_Sysdate DATE := Sysdate;
12142:
12143: BEGIN
12144:
12145: -- Standard start of API savepoint
12146: IF FND_API.To_Boolean(p_commit) THEN
12147: SAVEPOINT Create_Mapping_PUB;
12148: END IF;
12149:
12198: ,g_current_user_id
12199: ,g_current_login_id
12200: );
12201:
12202: -- Standard check of p_commit
12203: IF FND_API.To_Boolean(p_commit) THEN
12204: COMMIT WORK;
12205: END IF;
12206:
12255: l_mapping_group_type VARCHAR2(30);
12256:
12257: BEGIN
12258:
12259: -- Standard start of API savepoint
12260: IF FND_API.TO_BOOLEAN(p_commit) THEN
12261: SAVEPOINT Create_Mapping_PUB;
12262: END IF;
12263:
12287: ,x_msg_count => x_msg_count
12288: ,x_msg_data => x_msg_data
12289: );
12290:
12291: -- Standard check of p_commit
12292: IF FND_API.To_Boolean(p_commit) THEN
12293: COMMIT WORK;
12294: END IF;
12295:
12355: l_Sysdate DATE := Sysdate;
12356:
12357: BEGIN
12358:
12359: -- Standard start of API savepoint
12360: IF FND_API.To_Boolean(p_commit) THEN
12361: SAVEPOINT Update_Mapping_PUB;
12362: END IF;
12363:
12424: FUNC_PARAM_ID = p_func_param_id;
12425:
12426: END IF;
12427:
12428: -- Standard check of p_commit
12429: IF FND_API.To_Boolean(p_commit) THEN
12430: COMMIT WORK;
12431: END IF;
12432:
12487: l_mapping_group_type VARCHAR2(30);
12488:
12489: BEGIN
12490:
12491: -- Standard start of API savepoint
12492: IF FND_API.TO_BOOLEAN(p_commit) THEN
12493: SAVEPOINT Update_Mapping_PUB;
12494: END IF;
12495:
12526: ,x_msg_count => x_msg_count
12527: ,x_msg_data => x_msg_data
12528: );
12529:
12530: -- Standard check of p_commit
12531: IF FND_API.To_Boolean(p_commit) THEN
12532: COMMIT WORK;
12533: END IF;
12534: EXCEPTION
12578: l_api_version CONSTANT NUMBER := 1.0;
12579:
12580: BEGIN
12581:
12582: -- Standard start of API savepoint
12583: IF FND_API.To_Boolean(p_commit) THEN
12584: SAVEPOINT Update_Mapping_PUB;
12585: END IF;
12586:
12600: FUNCTION_ID = p_function_id AND
12601: MAPPED_OBJ_TYPE = p_mapped_obj_type AND
12602: MAPPED_OBJ_PK1_VAL = p_mapped_obj_pk1_value;
12603:
12604: -- Standard check of p_commit
12605: IF FND_API.To_Boolean(p_commit) THEN
12606: COMMIT WORK;
12607: END IF;
12608:
12652: l_api_version CONSTANT NUMBER := 1.0;
12653:
12654: BEGIN
12655:
12656: -- Standard start of API savepoint
12657: IF FND_API.To_Boolean(p_commit) THEN
12658: SAVEPOINT Delete_Func_Param_Mapping_PUB;
12659: END IF;
12660:
12675: MAPPED_OBJ_TYPE = p_mapped_obj_type AND
12676: MAPPED_OBJ_PK1_VAL = p_mapped_obj_pk1_value AND
12677: FUNC_PARAM_ID = p_func_param_id;
12678:
12679: -- Standard check of p_commit
12680: IF FND_API.To_Boolean(p_commit) THEN
12681: COMMIT WORK;
12682: END IF;
12683:
12737: l_Sysdate DATE := Sysdate;
12738:
12739: BEGIN
12740:
12741: -- Standard start of API savepoint
12742: IF FND_API.To_Boolean(p_commit) THEN
12743: SAVEPOINT Create_Action_Group_PUB;
12744: END IF;
12745:
12810:
12811: FROM FND_LANGUAGES L
12812: WHERE L.INSTALLED_FLAG in ('I', 'B');
12813:
12814: -- Standard check of p_commit
12815: IF FND_API.To_Boolean(p_commit) THEN
12816: COMMIT WORK;
12817: END IF;
12818:
12864: l_Sysdate DATE := Sysdate;
12865:
12866: BEGIN
12867:
12868: -- Standard start of API savepoint
12869: IF FND_API.To_Boolean(p_commit) THEN
12870: SAVEPOINT Update_Action_Group_PUB;
12871: END IF;
12872:
12904: WHERE
12905: -- ACTION_GROUP_ID = p_action_group_id AND LANGUAGE = USERENV('LANG');
12906: ACTION_GROUP_ID = p_action_group_id AND USERENV('LANG') IN (LANGUAGE , SOURCE_LANG);
12907:
12908: -- Standard check of p_commit
12909: IF FND_API.To_Boolean(p_commit) THEN
12910: COMMIT WORK;
12911: END IF;
12912:
12952: l_api_version CONSTANT NUMBER := 1.0;
12953:
12954: BEGIN
12955:
12956: -- Standard start of API savepoint
12957: IF FND_API.To_Boolean(p_commit) THEN
12958: SAVEPOINT Delete_Action_Group_PUB;
12959: END IF;
12960:
12982: DELETE FROM EGO_ACTION_GROUPS_TL
12983: WHERE
12984: ACTION_GROUP_ID = p_action_group_id;
12985:
12986: -- Standard check of p_commit
12987: IF FND_API.To_Boolean(p_commit) THEN
12988: COMMIT WORK;
12989: END IF;
12990:
13041: l_exist_action_count NUMBER := 0;
13042:
13043: BEGIN
13044:
13045: -- Standard start of API savepoint
13046: IF FND_API.To_Boolean(p_commit) THEN
13047: SAVEPOINT Create_Action_Group_Entry_PUB;
13048: END IF;
13049:
13088: ,g_current_login_id
13089: );
13090: END IF;
13091:
13092: -- Standard check of p_commit
13093: IF FND_API.To_Boolean(p_commit) THEN
13094: COMMIT WORK;
13095: END IF;
13096:
13141: l_exist_action_count NUMBER := 0;
13142:
13143: BEGIN
13144:
13145: -- Standard start of API savepoint
13146: IF FND_API.To_Boolean(p_commit) THEN
13147: SAVEPOINT Update_Action_Group_Entry_PUB;
13148: END IF;
13149:
13162: SET SEQUENCE = p_sequence
13163: WHERE ACTION_GROUP_ID = p_action_group_id
13164: AND ACTION_ID = p_action_id;
13165:
13166: -- Standard check of p_commit
13167: IF FND_API.To_Boolean(p_commit) THEN
13168: COMMIT WORK;
13169: END IF;
13170:
13211: l_api_version CONSTANT NUMBER := 1.0;
13212:
13213: BEGIN
13214:
13215: -- Standard start of API savepoint
13216: IF FND_API.To_Boolean(p_commit) THEN
13217: SAVEPOINT Update_Action_Group_Entry_PUB;
13218: END IF;
13219:
13232: WHERE
13233: ACTION_GROUP_ID = p_action_group_id AND
13234: ACTION_ID = p_action_id;
13235:
13236: -- Standard check of p_commit
13237: IF FND_API.To_Boolean(p_commit) THEN
13238: COMMIT WORK;
13239: END IF;
13240:
13778: l_agv_name ego_fnd_dsc_flx_ctx_ext.agv_name%TYPE;
13779: l_temp_agv_name ego_fnd_dsc_flx_ctx_ext.agv_name%TYPE;
13780:
13781: BEGIN
13782: -- Standard Start of API savepoint
13783: IF FND_API.To_Boolean( p_commit ) THEN
13784: SAVEPOINT Update_AGV_Name ;
13785: END IF;
13786: -- Check for call compatibility.
13980: END IF;
13981:
13982:
13983:
13984: -- Standard check of p_commit
13985: IF FND_API.To_Boolean(p_commit) THEN
13986: COMMIT WORK;
13987: END IF;
13988: