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.INV_COPY_ORGANIZATION_REPORT dependencies on STANDARD

Line 60: --| to Validate StandardOperations created for new org |

56: --| in comparing Bom |
57: --| 20/01/2006 myerrams Replaced the view BOM_BILL_OF_MATERIALS |
58: --| with BOM_STRUCTURES_B table. Bug: 4913484. |
59: --| 26/12/2006 myerrams Bug5592181 Added New function Get_Err_StdOperations|
60: --| to Validate StandardOperations created for new org |
61: --| against those in model org. |
62: --+===========================================================================+
63:
64: --=============================================================================

Line 115: -- p_api_version REQUIRED. As per standards.

111: -- COMMENTS : PL/SQL API called from Before_Report trigger of the
112: -- report. Calls initialize(), Validate_Locs() and
113: -- Validate_Orgs() functions to generate report data.
114: -- PARAMETERS :
115: -- p_api_version REQUIRED. As per standards.
116: -- p_init_msg_list REQUIRED. As per standards.
117: -- p_commit REQUIRED. As per standards.
118: -- x_return_status REQUIRED. Value can be
119: -- FND_API.G_RET_STS_SUCCESS

Line 116: -- p_init_msg_list REQUIRED. As per standards.

112: -- report. Calls initialize(), Validate_Locs() and
113: -- Validate_Orgs() functions to generate report data.
114: -- PARAMETERS :
115: -- p_api_version REQUIRED. As per standards.
116: -- p_init_msg_list REQUIRED. As per standards.
117: -- p_commit REQUIRED. As per standards.
118: -- x_return_status REQUIRED. Value can be
119: -- FND_API.G_RET_STS_SUCCESS
120: -- FND_API.G_RET_STS_ERROR

Line 117: -- p_commit REQUIRED. As per standards.

113: -- Validate_Orgs() functions to generate report data.
114: -- PARAMETERS :
115: -- p_api_version REQUIRED. As per standards.
116: -- p_init_msg_list REQUIRED. As per standards.
117: -- p_commit REQUIRED. As per standards.
118: -- x_return_status REQUIRED. Value can be
119: -- FND_API.G_RET_STS_SUCCESS
120: -- FND_API.G_RET_STS_ERROR
121: -- FND_API.G_RET_STS_UNEXP_ERROR

Line 122: -- x_msg_count REQUIRED. As per standards.

118: -- x_return_status REQUIRED. Value can be
119: -- FND_API.G_RET_STS_SUCCESS
120: -- FND_API.G_RET_STS_ERROR
121: -- FND_API.G_RET_STS_UNEXP_ERROR
122: -- x_msg_count REQUIRED. As per standards.
123: -- x_msg_data REQUIRED. As per standards.
124: -- p_group_code REQUIRED. Group code created for Copy Org request.
125: -- p_model_org_code REQUIRED. Model organization to copy from.
126: -- p_organization_code REQUIRED. New organization to be created.

Line 123: -- x_msg_data REQUIRED. As per standards.

119: -- FND_API.G_RET_STS_SUCCESS
120: -- FND_API.G_RET_STS_ERROR
121: -- FND_API.G_RET_STS_UNEXP_ERROR
122: -- x_msg_count REQUIRED. As per standards.
123: -- x_msg_data REQUIRED. As per standards.
124: -- p_group_code REQUIRED. Group code created for Copy Org request.
125: -- p_model_org_code REQUIRED. Model organization to copy from.
126: -- p_organization_code REQUIRED. New organization to be created.
127: -- p_copy_boms REQUIRED. Flag indicating to Copy BOMs.

Line 179: -- Standard Start of API savepoint

175: --l_msg_data VARCHAR2(100);
176:
177: BEGIN
178: -----------------------------------------------------------------------------
179: -- Standard Start of API savepoint
180: -----------------------------------------------------------------------------
181: SAVEPOINT Generate_Report_Data_PVT;
182:
183: IF G_DEBUG_LEVEL = '6'

Line 295: -- Standard check of p_commit.

291: -- to the Report Table : MTL_COPY_ORG_REPORT.
292: -------------------------------------------------------------------------
293: Validate_Orgs();
294: -------------------------------------------------------------------------
295: -- Standard check of p_commit.
296: -------------------------------------------------------------------------
297: x_return_status := FND_API.G_RET_STS_SUCCESS;
298: IF FND_API.To_Boolean( p_commit ) THEN
299: COMMIT WORK;

Line 972: Init_Vars('STANDARD_OPERATIONS');

968: Init_Vars('BOM_DEPARTMENT_CLASSES');
969: g_entity_names := Get_Err_Bom_Dept_Classes;
970: Put_Report_Data;
971:
972: Init_Vars('STANDARD_OPERATIONS');
973: g_entity_names := Get_Err_StdOperations;
974: Put_Report_Data;
975:
976: Init_Vars('ROUTINGS');

Line 2727: -- DESCRIPTION : Validate StandardOperations created for new org against

2723:
2724: --=============================================================================
2725: -- FUNCTION NAME : Get_Err_StdOperations
2726: -- PRE-CONDITIONS: None.
2727: -- DESCRIPTION : Validate StandardOperations created for new org against
2728: -- those in model org.
2729: -- PARAMETERS :
2730: -- EXCEPTIONS : None.
2731: --

Line 2748: l_std_op_code BOM_STANDARD_OPERATIONS.OPERATION_CODE%TYPE;

2744: l_count_tmp NUMBER:=0;
2745: l_entity_names Char_Array := Char_Array();
2746: l_entity_names_fin Char_Array := Char_Array();
2747: l_entity_arr_idx NUMBER := 1;
2748: l_std_op_code BOM_STANDARD_OPERATIONS.OPERATION_CODE%TYPE;
2749: -------------------------------------------------------------------
2750: -------------------------------------------------------------------
2751: CURSOR l_parent ( p_model_org_id NUMBER
2752: , p_organization_id NUMBER

Line 2756: FROM BOM_STANDARD_OPERATIONS stdops

2752: , p_organization_id NUMBER
2753: )
2754: IS
2755: SELECT DISTINCT stdops.OPERATION_CODE
2756: FROM BOM_STANDARD_OPERATIONS stdops
2757: WHERE stdops.ORGANIZATION_ID = p_model_org_id
2758: AND stdops.Line_Id is null and stdops.Operation_type = 1 --myerrams, testing
2759: AND NOT EXISTS
2760: ( SELECT 'x'

Line 2761: FROM BOM_STANDARD_OPERATIONS stdops1

2757: WHERE stdops.ORGANIZATION_ID = p_model_org_id
2758: AND stdops.Line_Id is null and stdops.Operation_type = 1 --myerrams, testing
2759: AND NOT EXISTS
2760: ( SELECT 'x'
2761: FROM BOM_STANDARD_OPERATIONS stdops1
2762: WHERE stdops1.ORGANIZATION_ID = p_organization_id
2763: AND stdops1.OPERATION_CODE = stdops.OPERATION_CODE
2764: );
2765:

Line 2768: SELECT COUNT(stdops.STANDARD_OPERATION_ID)

2764: );
2765:
2766: CURSOR l_parent_cnt ( p_org_id NUMBER )
2767: IS
2768: SELECT COUNT(stdops.STANDARD_OPERATION_ID)
2769: FROM BOM_STANDARD_OPERATIONS stdops
2770: WHERE stdops.ORGANIZATION_ID = p_org_id
2771: AND stdops.Line_Id is null and stdops.Operation_type = 1; --myerrams, testing
2772: -------------------------------------------------------------------

Line 2769: FROM BOM_STANDARD_OPERATIONS stdops

2765:
2766: CURSOR l_parent_cnt ( p_org_id NUMBER )
2767: IS
2768: SELECT COUNT(stdops.STANDARD_OPERATION_ID)
2769: FROM BOM_STANDARD_OPERATIONS stdops
2770: WHERE stdops.ORGANIZATION_ID = p_org_id
2771: AND stdops.Line_Id is null and stdops.Operation_type = 1; --myerrams, testing
2772: -------------------------------------------------------------------
2773: -------------------------------------------------------------------

Line 2781: , BOM_STANDARD_OPERATIONS stdops

2777: IS
2778: SELECT stdops.OPERATION_CODE
2779: , COUNT(stdopres.RESOURCE_ID)
2780: FROM BOM_STD_OP_RESOURCES stdopres
2781: , BOM_STANDARD_OPERATIONS stdops
2782: , BOM_RESOURCES res
2783: WHERE stdopres.STANDARD_OPERATION_ID = stdops.STANDARD_OPERATION_ID
2784: AND stdops.ORGANIZATION_ID = p_model_org_id
2785: AND stdops.Line_Id is null and stdops.Operation_type = 1 --myerrams, testing

Line 2783: WHERE stdopres.STANDARD_OPERATION_ID = stdops.STANDARD_OPERATION_ID

2779: , COUNT(stdopres.RESOURCE_ID)
2780: FROM BOM_STD_OP_RESOURCES stdopres
2781: , BOM_STANDARD_OPERATIONS stdops
2782: , BOM_RESOURCES res
2783: WHERE stdopres.STANDARD_OPERATION_ID = stdops.STANDARD_OPERATION_ID
2784: AND stdops.ORGANIZATION_ID = p_model_org_id
2785: AND stdops.Line_Id is null and stdops.Operation_type = 1 --myerrams, testing
2786: AND res.RESOURCE_ID = stdopres.RESOURCE_ID
2787:

Line 2791: , BOM_STANDARD_OPERATIONS stdops1

2787:
2788: AND NOT EXISTS
2789: ( SELECT 'x'
2790: FROM BOM_STD_OP_RESOURCES stdopres1
2791: , BOM_STANDARD_OPERATIONS stdops1
2792: , BOM_RESOURCES res1
2793: WHERE stdops1.ORGANIZATION_ID = p_organization_id
2794: AND stdopres1.STANDARD_OPERATION_ID = stdops1.STANDARD_OPERATION_ID
2795: AND stdopres1.RESOURCE_SEQ_NUM = stdopres.RESOURCE_SEQ_NUM

Line 2794: AND stdopres1.STANDARD_OPERATION_ID = stdops1.STANDARD_OPERATION_ID

2790: FROM BOM_STD_OP_RESOURCES stdopres1
2791: , BOM_STANDARD_OPERATIONS stdops1
2792: , BOM_RESOURCES res1
2793: WHERE stdops1.ORGANIZATION_ID = p_organization_id
2794: AND stdopres1.STANDARD_OPERATION_ID = stdops1.STANDARD_OPERATION_ID
2795: AND stdopres1.RESOURCE_SEQ_NUM = stdopres.RESOURCE_SEQ_NUM
2796: AND res1.RESOURCE_ID = stdopres1.RESOURCE_ID
2797: AND res1.RESOURCE_CODE = res.RESOURCE_CODE
2798: AND stdops1.OPERATION_CODE = stdops.OPERATION_CODE --myerrams, testing

Line 2806: , BOM_STANDARD_OPERATIONS stdops

2802: CURSOR l_child_1_cnt ( p_org_id NUMBER )
2803: IS
2804: SELECT COUNT(stdopres.RESOURCE_ID)
2805: FROM BOM_STD_OP_RESOURCES stdopres
2806: , BOM_STANDARD_OPERATIONS stdops
2807: WHERE stdopres.STANDARD_OPERATION_ID = stdops.STANDARD_OPERATION_ID
2808: AND stdops.Line_Id is null and stdops.Operation_type = 1 --myerrams, testing
2809: AND stdops.ORGANIZATION_ID = p_org_id;
2810: -------------------------------------------------------------------

Line 2807: WHERE stdopres.STANDARD_OPERATION_ID = stdops.STANDARD_OPERATION_ID

2803: IS
2804: SELECT COUNT(stdopres.RESOURCE_ID)
2805: FROM BOM_STD_OP_RESOURCES stdopres
2806: , BOM_STANDARD_OPERATIONS stdops
2807: WHERE stdopres.STANDARD_OPERATION_ID = stdops.STANDARD_OPERATION_ID
2808: AND stdops.Line_Id is null and stdops.Operation_type = 1 --myerrams, testing
2809: AND stdops.ORGANIZATION_ID = p_org_id;
2810: -------------------------------------------------------------------
2811: -------------------------------------------------------------------

Line 2820: , BOM_STANDARD_OPERATIONS stdops

2816: SELECT stdops.OPERATION_CODE
2817: , COUNT(stdsubopres.SUBSTITUTE_GROUP_NUM)
2818: FROM BOM_STD_SUB_OP_RESOURCES stdsubopres
2819: , BOM_STD_OP_RESOURCES stdopres
2820: , BOM_STANDARD_OPERATIONS stdops
2821: , BOM_RESOURCES res
2822: WHERE stdops.ORGANIZATION_ID = p_model_org_id
2823: AND stdops.Line_Id is null and stdops.Operation_type = 1 --myerrams, testing
2824: AND stdopres.SUBSTITUTE_GROUP_NUM = stdsubopres.SUBSTITUTE_GROUP_NUM

Line 2825: AND stdops.STANDARD_OPERATION_ID = stdopres.STANDARD_OPERATION_ID

2821: , BOM_RESOURCES res
2822: WHERE stdops.ORGANIZATION_ID = p_model_org_id
2823: AND stdops.Line_Id is null and stdops.Operation_type = 1 --myerrams, testing
2824: AND stdopres.SUBSTITUTE_GROUP_NUM = stdsubopres.SUBSTITUTE_GROUP_NUM
2825: AND stdops.STANDARD_OPERATION_ID = stdopres.STANDARD_OPERATION_ID
2826: AND stdops.STANDARD_OPERATION_ID = stdsubopres.STANDARD_OPERATION_ID
2827: AND res.RESOURCE_ID = stdsubopres.RESOURCE_ID
2828: AND NOT EXISTS
2829: ( SELECT 'x'

Line 2826: AND stdops.STANDARD_OPERATION_ID = stdsubopres.STANDARD_OPERATION_ID

2822: WHERE stdops.ORGANIZATION_ID = p_model_org_id
2823: AND stdops.Line_Id is null and stdops.Operation_type = 1 --myerrams, testing
2824: AND stdopres.SUBSTITUTE_GROUP_NUM = stdsubopres.SUBSTITUTE_GROUP_NUM
2825: AND stdops.STANDARD_OPERATION_ID = stdopres.STANDARD_OPERATION_ID
2826: AND stdops.STANDARD_OPERATION_ID = stdsubopres.STANDARD_OPERATION_ID
2827: AND res.RESOURCE_ID = stdsubopres.RESOURCE_ID
2828: AND NOT EXISTS
2829: ( SELECT 'x'
2830: FROM BOM_STD_SUB_OP_RESOURCES stdsubopres1

Line 2832: , BOM_STANDARD_OPERATIONS stdops1

2828: AND NOT EXISTS
2829: ( SELECT 'x'
2830: FROM BOM_STD_SUB_OP_RESOURCES stdsubopres1
2831: , BOM_STD_OP_RESOURCES stdopres1
2832: , BOM_STANDARD_OPERATIONS stdops1
2833: , BOM_RESOURCES res1
2834: WHERE stdops1.STANDARD_OPERATION_ID = stdsubopres1.STANDARD_OPERATION_ID
2835: AND stdops1.STANDARD_OPERATION_ID = stdopres1.STANDARD_OPERATION_ID
2836: AND stdops1.ORGANIZATION_ID = p_organization_id

Line 2834: WHERE stdops1.STANDARD_OPERATION_ID = stdsubopres1.STANDARD_OPERATION_ID

2830: FROM BOM_STD_SUB_OP_RESOURCES stdsubopres1
2831: , BOM_STD_OP_RESOURCES stdopres1
2832: , BOM_STANDARD_OPERATIONS stdops1
2833: , BOM_RESOURCES res1
2834: WHERE stdops1.STANDARD_OPERATION_ID = stdsubopres1.STANDARD_OPERATION_ID
2835: AND stdops1.STANDARD_OPERATION_ID = stdopres1.STANDARD_OPERATION_ID
2836: AND stdops1.ORGANIZATION_ID = p_organization_id
2837: AND res1.RESOURCE_ID = stdsubopres1.RESOURCE_ID
2838: AND res1.RESOURCE_CODE = res.RESOURCE_CODE

Line 2835: AND stdops1.STANDARD_OPERATION_ID = stdopres1.STANDARD_OPERATION_ID

2831: , BOM_STD_OP_RESOURCES stdopres1
2832: , BOM_STANDARD_OPERATIONS stdops1
2833: , BOM_RESOURCES res1
2834: WHERE stdops1.STANDARD_OPERATION_ID = stdsubopres1.STANDARD_OPERATION_ID
2835: AND stdops1.STANDARD_OPERATION_ID = stdopres1.STANDARD_OPERATION_ID
2836: AND stdops1.ORGANIZATION_ID = p_organization_id
2837: AND res1.RESOURCE_ID = stdsubopres1.RESOURCE_ID
2838: AND res1.RESOURCE_CODE = res.RESOURCE_CODE
2839: AND stdopres1.SUBSTITUTE_GROUP_NUM = stdsubopres1.SUBSTITUTE_GROUP_NUM

Line 2850: , BOM_STANDARD_OPERATIONS stdops

2846: IS
2847: SELECT COUNT(stdsubopres.SUBSTITUTE_GROUP_NUM)
2848: FROM BOM_STD_SUB_OP_RESOURCES stdsubopres
2849: , BOM_STD_OP_RESOURCES stdopres
2850: , BOM_STANDARD_OPERATIONS stdops
2851: WHERE stdops.ORGANIZATION_ID = p_org_id
2852: AND stdops.Line_Id is null and stdops.Operation_type = 1 --myerrams, testing
2853: AND stdopres.SUBSTITUTE_GROUP_NUM = stdsubopres.SUBSTITUTE_GROUP_NUM
2854: AND stdops.STANDARD_OPERATION_ID = stdopres.STANDARD_OPERATION_ID

Line 2854: AND stdops.STANDARD_OPERATION_ID = stdopres.STANDARD_OPERATION_ID

2850: , BOM_STANDARD_OPERATIONS stdops
2851: WHERE stdops.ORGANIZATION_ID = p_org_id
2852: AND stdops.Line_Id is null and stdops.Operation_type = 1 --myerrams, testing
2853: AND stdopres.SUBSTITUTE_GROUP_NUM = stdsubopres.SUBSTITUTE_GROUP_NUM
2854: AND stdops.STANDARD_OPERATION_ID = stdopres.STANDARD_OPERATION_ID
2855: AND stdops.STANDARD_OPERATION_ID = stdsubopres.STANDARD_OPERATION_ID;
2856: -------------------------------------------------------------------
2857: -------------------------------------------------------------------
2858: BEGIN

Line 2855: AND stdops.STANDARD_OPERATION_ID = stdsubopres.STANDARD_OPERATION_ID;

2851: WHERE stdops.ORGANIZATION_ID = p_org_id
2852: AND stdops.Line_Id is null and stdops.Operation_type = 1 --myerrams, testing
2853: AND stdopres.SUBSTITUTE_GROUP_NUM = stdsubopres.SUBSTITUTE_GROUP_NUM
2854: AND stdops.STANDARD_OPERATION_ID = stdopres.STANDARD_OPERATION_ID
2855: AND stdops.STANDARD_OPERATION_ID = stdsubopres.STANDARD_OPERATION_ID;
2856: -------------------------------------------------------------------
2857: -------------------------------------------------------------------
2858: BEGIN
2859: