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.CST_PERIODIC_ABSORPTION_PROC dependencies on CST_PERIODIC_ABSORPTION_PROC

Line 1: PACKAGE BODY CST_PERIODIC_ABSORPTION_PROC AS

1: PACKAGE BODY CST_PERIODIC_ABSORPTION_PROC AS
2: -- $Header: CSTRITPB.pls 120.62.12020000.5 2013/04/05 12:12:14 pbasrani ship $
3: --+=======================================================================+
4: --| Copyright (c) 2003 Oracle Corporation |
5: --| Redwood Shores, CA, USA |

Line 40: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CST_PERIODIC_ABSORPTION_PROC';

36: --===================
37: -- GLOBALS
38: --===================
39:
40: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CST_PERIODIC_ABSORPTION_PROC';
41: g_org_id NUMBER := FND_PROFILE.value('ORG_ID');
42: -- to store the item and its BOM highest level across cost groups
43: TYPE item_level_rec_type IS RECORD
44: ( inventory_item_id NUMBER

Line 1718: ,p_cg_tab IN CST_PERIODIC_ABSORPTION_PROC.tbl_type

1714: ,p_period_id IN NUMBER
1715: ,p_start_date IN DATE
1716: ,p_end_date IN DATE
1717: ,p_prev_period_id IN NUMBER
1718: ,p_cg_tab IN CST_PERIODIC_ABSORPTION_PROC.tbl_type
1719: ,p_inventory_item_id IN NUMBER
1720: ,p_uom_control IN NUMBER
1721: ,p_pac_rates_id IN NUMBER
1722: ,p_mat_relief_algorithm IN NUMBER

Line 2566: ,p_cg_tab IN CST_PERIODIC_ABSORPTION_PROC.tbl_type

2562: ,p_period_id IN NUMBER
2563: ,p_start_date IN DATE
2564: ,p_end_date IN DATE
2565: ,p_prev_period_id IN NUMBER
2566: ,p_cg_tab IN CST_PERIODIC_ABSORPTION_PROC.tbl_type
2567: ,p_inventory_item_id IN NUMBER
2568: ,p_uom_control IN NUMBER
2569: ,p_pac_rates_id IN NUMBER
2570: ,p_mat_relief_algorithm IN NUMBER

Line 2630: CST_PERIODIC_ABSORPTION_PROC.Process_Non_Rework_Comps

2626: -- ===================================================================
2627: -- Process WIP transactions
2628: -- ===================================================================
2629: -- Process non-rework assembly completion transactons
2630: CST_PERIODIC_ABSORPTION_PROC.Process_Non_Rework_Comps
2631: (p_period_id => p_period_id
2632: ,p_start_date => p_start_date
2633: ,p_end_date => p_end_date
2634: ,p_prev_period_id => p_prev_period_id

Line 2652: CST_PERIODIC_ABSORPTION_PROC.Process_Rework_Issue_Comps

2648: ,p_prg_id => p_prg_id
2649: ,p_prg_appid => p_prg_appid);
2650:
2651: -- Process rework assembly issue and completion transactons
2652: CST_PERIODIC_ABSORPTION_PROC.Process_Rework_Issue_Comps
2653: (p_period_id => p_period_id
2654: ,p_start_date => p_start_date
2655: ,p_end_date => p_end_date
2656: ,p_prev_period_id => p_prev_period_id

Line 3088: , '>> CST_PERIODIC_ABSORPTION_PROC:validate_uncosted_txns'

3084: BEGIN
3085:
3086: FND_FILE.put_line
3087: ( FND_FILE.log
3088: , '>> CST_PERIODIC_ABSORPTION_PROC:validate_uncosted_txns'
3089: );
3090:
3091: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3092: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 3334: , '<< CST_PERIODIC_ABSORPTION_PROC:validate_uncosted_txns'

3330:
3331:
3332: FND_FILE.put_line
3333: ( FND_FILE.log
3334: , '<< CST_PERIODIC_ABSORPTION_PROC:validate_uncosted_txns'
3335: );
3336:
3337: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3338: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 3385: ,p_cg_tab IN CST_PERIODIC_ABSORPTION_PROC.tbl_type

3381: -- : Period
3382: -- =======================================================================
3383: PROCEDURE Insert_Ending_Balance_All_Cgs
3384: (p_pac_period_id IN NUMBER
3385: ,p_cg_tab IN CST_PERIODIC_ABSORPTION_PROC.tbl_type
3386: ,p_end_date IN DATE
3387: ,p_user_id IN NUMBER
3388: ,p_login_id IN NUMBER
3389: ,p_req_id IN NUMBER

Line 3408: , '>> CST_PERIODIC_ABSORPTION_PROC.Insert_Ending_Balance_All_Cgs'

3404: BEGIN
3405:
3406: FND_FILE.put_line
3407: ( FND_FILE.log
3408: , '>> CST_PERIODIC_ABSORPTION_PROC.Insert_Ending_Balance_All_Cgs'
3409: );
3410:
3411: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3412: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 3455: , '<< CST_PERIODIC_ABSORPTION_PROC.Insert_Ending_Balance_All_Cgs'

3451: END LOOP;
3452:
3453: FND_FILE.put_line
3454: ( FND_FILE.log
3455: , '<< CST_PERIODIC_ABSORPTION_PROC.Insert_Ending_Balance_All_Cgs'
3456: );
3457:
3458: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3459: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 3574: ,p_cg_tab IN CST_PERIODIC_ABSORPTION_PROC.tbl_type

3570: (p_period_id IN NUMBER
3571: ,p_prev_period_id IN NUMBER
3572: ,p_legal_entity IN NUMBER
3573: ,p_cost_type_id IN NUMBER
3574: ,p_cg_tab IN CST_PERIODIC_ABSORPTION_PROC.tbl_type
3575: ,p_run_options IN NUMBER
3576: ,p_number_of_iterations IN NUMBER
3577: ,p_cost_method IN NUMBER
3578: ,p_start_date IN DATE

Line 3786: CST_PERIODIC_ABSORPTION_PROC.G_ITEM_LEVEL_TBL.DELETE;

3782:
3783: FOR l_current_level_idx IN REVERSE l_topmost_absl_level_code .. l_lowest_absl_level_code LOOP
3784:
3785: -- Purge private pl/sql table G_ITEM_LEVEL_TBL containing previous level items
3786: CST_PERIODIC_ABSORPTION_PROC.G_ITEM_LEVEL_TBL.DELETE;
3787:
3788: l_current_level_code := l_current_level_idx;
3789:
3790: -- Display current BOM level code

Line 4020: CST_PERIODIC_ABSORPTION_PROC.Periodic_Cost_Update_By_Level

4016:
4017: -- Periodic Cost Update value change only for non-interorg items in
4018: -- the cost group where the same item is an interorg item in other cost groups.
4019: -- both completion and no completion items are included
4020: CST_PERIODIC_ABSORPTION_PROC.Periodic_Cost_Update_By_Level
4021: (p_period_id => p_period_id
4022: ,p_legal_entity => p_legal_entity
4023: ,p_cost_type_id => p_cost_type_id
4024: ,p_cost_group_id => p_cg_tab(l_cg_idx).cost_group_id

Line 4140: CST_PERIODIC_ABSORPTION_PROC.Periodic_Cost_Update_By_Level

4136: CLOSE c_low_level_code_cg_cur;
4137:
4138: -- Periodic Cost Update value change only for non-interorg items
4139: -- both completion and no completion items are included
4140: CST_PERIODIC_ABSORPTION_PROC.Periodic_Cost_Update_By_Level
4141: (p_period_id => p_period_id
4142: ,p_legal_entity => p_legal_entity
4143: ,p_cost_type_id => p_cost_type_id
4144: ,p_cost_group_id => p_cg_tab(l_cg_idx).cost_group_id

Line 4570: , '>> CST_PERIODIC_ABSORPTION_PROC:process_logical_txns'

4566: BEGIN
4567:
4568: FND_FILE.put_line
4569: ( FND_FILE.log
4570: , '>> CST_PERIODIC_ABSORPTION_PROC:process_logical_txns'
4571: );
4572:
4573: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4574: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 4653: , '<< CST_PERIODIC_ABSORPTION_PROC:process_logical_txns'

4649: CLOSE logical_txn_cur;
4650:
4651: FND_FILE.put_line
4652: ( FND_FILE.log
4653: , '<< CST_PERIODIC_ABSORPTION_PROC:process_logical_txns'
4654: );
4655:
4656: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4657: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 4748: , p_cg_tab IN CST_PERIODIC_ABSORPTION_PROC.tbl_type

4744: , p_prev_period_id IN NUMBER
4745: , p_tolerance IN NUMBER
4746: , p_number_of_iterations IN NUMBER
4747: , p_number_of_workers IN NUMBER
4748: , p_cg_tab IN CST_PERIODIC_ABSORPTION_PROC.tbl_type
4749: , p_uom_control IN NUMBER
4750: , p_pac_rates_id IN NUMBER
4751: , p_mat_relief_algorithm IN NUMBER
4752: , p_start_date IN DATE

Line 4895: CST_PERIODIC_ABSORPTION_PROC.Absorption_Cost_Process

4891:
4892: -- ====================================================================
4893: -- Absorption Cost Rollup Process
4894: -- ====================================================================
4895: CST_PERIODIC_ABSORPTION_PROC.Absorption_Cost_Process
4896: (p_period_id => p_period_id
4897: ,p_prev_period_id => p_prev_period_id
4898: ,p_legal_entity => p_legal_entity
4899: ,p_cost_type_id => p_cost_type_id

Line 4924: CST_PERIODIC_ABSORPTION_PROC.get_phase_status(p_pac_period_id => p_period_id

4920: -- Process WIP Close transactions
4921: -- =============================================================================
4922:
4923: -- Check for Phase 7 completion and Phase 5 not yet completed
4924: CST_PERIODIC_ABSORPTION_PROC.get_phase_status(p_pac_period_id => p_period_id
4925: ,p_phase => 7
4926: ,p_cost_group_id => NULL
4927: ,x_status => l_phase7_status
4928: );

Line 4993: CST_PERIODIC_ABSORPTION_PROC.process_logical_txns

4989:
4990: END IF;
4991:
4992: -- Process Logical Transactions
4993: CST_PERIODIC_ABSORPTION_PROC.process_logical_txns
4994: (p_period_id => p_period_id
4995: ,p_legal_entity_id => p_legal_entity
4996: ,p_cost_type_id => p_cost_type_id
4997: ,p_cost_group_id => p_cg_tab(l_current_index).cost_group_id

Line 5169: CST_PERIODIC_ABSORPTION_PROC.validate_le_ct_association

5165:
5166: -- Call procedure to check the validity of cost type,
5167: -- legal entity and their association
5168:
5169: CST_PERIODIC_ABSORPTION_PROC.validate_le_ct_association
5170: (p_legal_entity => p_legal_entity
5171: ,p_cost_type_id => p_cost_type_id);
5172:
5173: -- Call procedure to check that the current period is open

Line 5176: CST_PERIODIC_ABSORPTION_PROC.validate_period

5172:
5173: -- Call procedure to check that the current period is open
5174: -- legal entity and their association
5175:
5176: CST_PERIODIC_ABSORPTION_PROC.validate_period
5177: (p_legal_entity => p_legal_entity
5178: ,p_cost_type_id => p_cost_type_id
5179: ,p_period_id => p_period_id);
5180:

Line 5182: CST_PERIODIC_ABSORPTION_PROC.validate_previous_period

5178: ,p_cost_type_id => p_cost_type_id
5179: ,p_period_id => p_period_id);
5180:
5181: -- Validate that previous period has been closed
5182: CST_PERIODIC_ABSORPTION_PROC.validate_previous_period
5183: (p_legal_entity => p_legal_entity
5184: ,p_cost_type_id => p_cost_type_id
5185: ,p_period_id => p_period_id
5186: ,x_prev_period_id => l_prev_period_id);

Line 5193: CST_PERIODIC_ABSORPTION_PROC.find_cost_method

5189: -- Find the cost method being used for this
5190: -- legal entity/cost type association
5191: -- It needs to be PAC
5192:
5193: CST_PERIODIC_ABSORPTION_PROC.find_cost_method
5194: (p_legal_entity => p_legal_entity
5195: ,p_cost_type_id => p_cost_type_id
5196: ,x_cost_method => l_cost_method);
5197:

Line 5205: CST_PERIODIC_ABSORPTION_PROC.validate_process_upto_date

5201: -- options process upto date should be NULL
5202:
5203: -- Bug#4351270 fix: time zone validate for process upto date
5204: -- with respect to Legal Entity
5205: CST_PERIODIC_ABSORPTION_PROC.validate_process_upto_date
5206: (p_process_upto_date => p_le_process_upto_date
5207: ,p_period_id => p_period_id
5208: ,p_run_options => p_run_options
5209: );

Line 5213: l_uom_control := CST_PERIODIC_ABSORPTION_PROC.get_uom_control_level;

5209: );
5210:
5211: -- Get Unit of Measure control level
5212:
5213: l_uom_control := CST_PERIODIC_ABSORPTION_PROC.get_uom_control_level;
5214:
5215:
5216: -- Find The Pac Rates and
5217: -- Material Relief Algorithm (introduced in R12)

Line 5218: CST_PERIODIC_ABSORPTION_PROC.find_pac_rates_algorithm

5214:
5215:
5216: -- Find The Pac Rates and
5217: -- Material Relief Algorithm (introduced in R12)
5218: CST_PERIODIC_ABSORPTION_PROC.find_pac_rates_algorithm
5219: (p_legal_entity => p_legal_entity
5220: ,p_cost_type_id => p_cost_type_id
5221: ,x_pac_rates_id => l_pac_rates_id
5222: ,x_mat_relief_algorithm => l_mat_relief_algorithm

Line 5260: CST_PERIODIC_ABSORPTION_PROC.find_period_duration

5256: -- period end date is the user entered process upto date
5257: -- For run options 3 - resume for non tolerance and 4 - final iteration
5258: -- l_end_date will be null since the user will not enter any
5259: -- process upto date in the input parameter screen
5260: CST_PERIODIC_ABSORPTION_PROC.find_period_duration
5261: (p_legal_entity => p_legal_entity
5262: ,p_cost_type_id => p_cost_type_id
5263: ,p_period_id => p_period_id
5264: ,p_process_upto_date => p_process_upto_date

Line 5272: l_end_date := CST_PERIODIC_ABSORPTION_PROC.Find_Prev_Process_Upto_Date

5268: -- get process upto date for run options 3 - resume for non tolerance
5269: -- and 4 - final iteration
5270: IF l_run_options > 1 THEN
5271:
5272: l_end_date := CST_PERIODIC_ABSORPTION_PROC.Find_Prev_Process_Upto_Date
5273: (p_pac_period_id => p_period_id);
5274: END IF;
5275:
5276: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5298: CST_PERIODIC_ABSORPTION_PROC.validate_cost_groups

5294: END IF;
5295:
5296: -- Call procedure to validate current cost group
5297:
5298: CST_PERIODIC_ABSORPTION_PROC.validate_cost_groups
5299: (p_legal_entity => p_legal_entity
5300: ,p_cost_type_id => p_cost_type_id
5301: ,p_period_id => p_period_id
5302: ,p_cost_group_id => l_txn_tab(l_current_index).cost_group_id);

Line 5307: CST_PERIODIC_ABSORPTION_PROC.validate_phases_seeded

5303:
5304: -- Ensure all appropriate phases in the process phases table
5305: -- are seeded correctly
5306:
5307: CST_PERIODIC_ABSORPTION_PROC.validate_phases_seeded
5308: (p_cost_group_id => l_txn_tab(l_current_index).cost_group_id
5309: ,p_period_id => p_period_id);
5310:
5311: -- check that the cost group has assignments

Line 5313: CST_PERIODIC_ABSORPTION_PROC.number_of_assignments

5309: ,p_period_id => p_period_id);
5310:
5311: -- check that the cost group has assignments
5312:
5313: CST_PERIODIC_ABSORPTION_PROC.number_of_assignments
5314: (p_cost_group_id => l_txn_tab(l_current_index).cost_group_id
5315: ,p_period_id => p_period_id
5316: ,p_user_id => l_user_id
5317: ,p_login_id => l_login_id

Line 5324: CST_PERIODIC_ABSORPTION_PROC.validate_master_org

5320: ,p_prg_appid => l_prg_appid);
5321:
5322: -- Validate Master Organization
5323:
5324: CST_PERIODIC_ABSORPTION_PROC.validate_master_org
5325: (p_legal_entity => p_legal_entity
5326: ,p_cost_type_id => p_cost_type_id
5327: ,p_cost_group_id => l_txn_tab(l_current_index).cost_group_id
5328: ,x_master_org_id => l_txn_tab(l_current_index).master_org_id);

Line 5333: CST_PERIODIC_ABSORPTION_PROC.find_starting_phase

5329:
5330: -- Find the starting Phase for the current cost group and
5331: -- store it in a pl/sql table of record
5332:
5333: CST_PERIODIC_ABSORPTION_PROC.find_starting_phase
5334: (p_legal_entity => p_legal_entity
5335: ,p_cost_type_id => p_cost_type_id
5336: ,p_period_id => p_period_id
5337: ,p_end_date => l_end_date

Line 5365: CST_PERIODIC_ABSORPTION_PROC.transfer_cp_worker

5361: -- processing of these records.
5362: -- if the the run option is 3 then this is a resumption
5363: -- of processing after an error.
5364:
5365: CST_PERIODIC_ABSORPTION_PROC.transfer_cp_worker
5366: (p_legal_entity => p_legal_entity
5367: ,p_cost_type_id => p_cost_type_id
5368: ,p_cost_method => l_cost_method
5369: ,p_period_id => p_period_id

Line 5436: END CST_PERIODIC_ABSORPTION_PROC;

5432: END IF;
5433:
5434: END transfer_cp_manager;
5435:
5436: END CST_PERIODIC_ABSORPTION_PROC;