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.GMF_BURDENDETAILS_PVT dependencies on CM_BRDN_DTL

Line 58: p_organization_id IN cm_brdn_dtl.organization_id%TYPE,

54: );
55: --
56: FUNCTION check_records_exist
57: (
58: p_organization_id IN cm_brdn_dtl.organization_id%TYPE,
59: p_inventory_item_id IN cm_brdn_dtl.inventory_item_id%TYPE,
60: p_resources IN cm_brdn_dtl.resources%TYPE,
61: p_period_id IN cm_brdn_dtl.period_id%TYPE,
62: p_cost_type_id IN cm_brdn_dtl.cost_type_id%TYPE ,

Line 59: p_inventory_item_id IN cm_brdn_dtl.inventory_item_id%TYPE,

55: --
56: FUNCTION check_records_exist
57: (
58: p_organization_id IN cm_brdn_dtl.organization_id%TYPE,
59: p_inventory_item_id IN cm_brdn_dtl.inventory_item_id%TYPE,
60: p_resources IN cm_brdn_dtl.resources%TYPE,
61: p_period_id IN cm_brdn_dtl.period_id%TYPE,
62: p_cost_type_id IN cm_brdn_dtl.cost_type_id%TYPE ,
63: p_cost_cmpntcls_id IN cm_brdn_dtl.cost_cmpntcls_id%TYPE,

Line 60: p_resources IN cm_brdn_dtl.resources%TYPE,

56: FUNCTION check_records_exist
57: (
58: p_organization_id IN cm_brdn_dtl.organization_id%TYPE,
59: p_inventory_item_id IN cm_brdn_dtl.inventory_item_id%TYPE,
60: p_resources IN cm_brdn_dtl.resources%TYPE,
61: p_period_id IN cm_brdn_dtl.period_id%TYPE,
62: p_cost_type_id IN cm_brdn_dtl.cost_type_id%TYPE ,
63: p_cost_cmpntcls_id IN cm_brdn_dtl.cost_cmpntcls_id%TYPE,
64: p_cost_analysis_code IN cm_brdn_dtl.cost_analysis_code%TYPE

Line 61: p_period_id IN cm_brdn_dtl.period_id%TYPE,

57: (
58: p_organization_id IN cm_brdn_dtl.organization_id%TYPE,
59: p_inventory_item_id IN cm_brdn_dtl.inventory_item_id%TYPE,
60: p_resources IN cm_brdn_dtl.resources%TYPE,
61: p_period_id IN cm_brdn_dtl.period_id%TYPE,
62: p_cost_type_id IN cm_brdn_dtl.cost_type_id%TYPE ,
63: p_cost_cmpntcls_id IN cm_brdn_dtl.cost_cmpntcls_id%TYPE,
64: p_cost_analysis_code IN cm_brdn_dtl.cost_analysis_code%TYPE
65: ) RETURN BOOLEAN;

Line 62: p_cost_type_id IN cm_brdn_dtl.cost_type_id%TYPE ,

58: p_organization_id IN cm_brdn_dtl.organization_id%TYPE,
59: p_inventory_item_id IN cm_brdn_dtl.inventory_item_id%TYPE,
60: p_resources IN cm_brdn_dtl.resources%TYPE,
61: p_period_id IN cm_brdn_dtl.period_id%TYPE,
62: p_cost_type_id IN cm_brdn_dtl.cost_type_id%TYPE ,
63: p_cost_cmpntcls_id IN cm_brdn_dtl.cost_cmpntcls_id%TYPE,
64: p_cost_analysis_code IN cm_brdn_dtl.cost_analysis_code%TYPE
65: ) RETURN BOOLEAN;
66:

Line 63: p_cost_cmpntcls_id IN cm_brdn_dtl.cost_cmpntcls_id%TYPE,

59: p_inventory_item_id IN cm_brdn_dtl.inventory_item_id%TYPE,
60: p_resources IN cm_brdn_dtl.resources%TYPE,
61: p_period_id IN cm_brdn_dtl.period_id%TYPE,
62: p_cost_type_id IN cm_brdn_dtl.cost_type_id%TYPE ,
63: p_cost_cmpntcls_id IN cm_brdn_dtl.cost_cmpntcls_id%TYPE,
64: p_cost_analysis_code IN cm_brdn_dtl.cost_analysis_code%TYPE
65: ) RETURN BOOLEAN;
66:
67: -- Global variables

Line 64: p_cost_analysis_code IN cm_brdn_dtl.cost_analysis_code%TYPE

60: p_resources IN cm_brdn_dtl.resources%TYPE,
61: p_period_id IN cm_brdn_dtl.period_id%TYPE,
62: p_cost_type_id IN cm_brdn_dtl.cost_type_id%TYPE ,
63: p_cost_cmpntcls_id IN cm_brdn_dtl.cost_cmpntcls_id%TYPE,
64: p_cost_analysis_code IN cm_brdn_dtl.cost_analysis_code%TYPE
65: ) RETURN BOOLEAN;
66:
67: -- Global variables
68: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMF_BurdenDetails_PVT';

Line 131: l_burdenline_id cm_brdn_dtl.burdenline_id%TYPE ;

127:
128: l_api_name CONSTANT VARCHAR2(30) := 'Create_Burden_Details' ;
129: l_api_version CONSTANT NUMBER := 2.0 ;
130:
131: l_burdenline_id cm_brdn_dtl.burdenline_id%TYPE ;
132: l_idx NUMBER(10) := 0 ;
133: BEGIN
134:
135: -- Standard Start of API savepoint

Line 203: INSERT INTO cm_brdn_dtl

199: -- In case of failure error msg will be logged and will continue with the next record
200: --
201:
202: BEGIN
203: INSERT INTO cm_brdn_dtl
204: (
205: burdenline_id
206: , resources
207: , cost_cmpntcls_id

Line 435: UPDATE cm_brdn_dtl

431: IF (p_dtl_tbl(i).burdenline_id IS NOT NULL) AND -- Bug 2659435 OR to AND
432: (p_dtl_tbl(i).burdenline_id <> FND_API.G_MISS_NUM) THEN
433:
434: IF p_dtl_tbl(i).delete_mark = 0 THEN -- Update
435: UPDATE cm_brdn_dtl
436: SET
437: /* Bug 2659435: key columns should not be changed.
438: resources = decode(p_dtl_tbl(i).resources
439: , FND_API.G_MISS_CHAR, NULL

Line 485: UPDATE cm_brdn_dtl

481: WHERE
482: burdenline_id = p_dtl_tbl(i).burdenline_id
483: ;
484: ELSE -- delete the record i.e mark for purge
485: UPDATE cm_brdn_dtl
486: SET
487: delete_mark = 1
488: -- , creation_date = sysdate -- Bug 2722404
489: -- , created_by = p_user_id

Line 526: UPDATE cm_brdn_dtl

522: END IF ;
523:
524: ELSE -- Burdenline_Id is not supplied.
525: IF p_dtl_tbl(i).delete_mark = 0 THEN -- Update
526: UPDATE cm_brdn_dtl
527: SET
528: /* Bug 2659435: key columns should not be changed.
529: resources = decode(p_dtl_tbl(i).resources
530: , FND_API.G_MISS_CHAR, NULL

Line 582: UPDATE cm_brdn_dtl

578: AND cost_cmpntcls_id = p_dtl_tbl(i).cost_cmpntcls_id
579: AND cost_analysis_code = p_dtl_tbl(i).cost_analysis_code
580: ;
581: ELSE -- delete the record i.e mark for purge
582: UPDATE cm_brdn_dtl
583: SET
584: delete_mark = 1
585: -- , creation_date = sysdate -- Bug 2722404
586: -- , created_by = p_user_id

Line 718: --| Function : Retrieve Burden Details based on the input from CM_BRDN_DTL|

714: --Start of comments
715: --+========================================================================+
716: --| API Name : Get_Burden_Details |
717: --| TYPE : Private |
718: --| Function : Retrieve Burden Details based on the input from CM_BRDN_DTL|
719: --| Pre-reqa : None. |
720: --| Parameters : |
721: --| IN : |
722: --| p_api_version IN NUMBER - Required |

Line 763: CURSOR cm_brdn_dtl

759: l_api_version CONSTANT NUMBER := 2.0 ;
760:
761: l_idx NUMBER := 0 ;
762:
763: CURSOR cm_brdn_dtl
764: IS
765: SELECT
766: b.burdenline_id
767: , b.resources

Line 779: cm_cmpt_mst c, cm_brdn_dtl b

775: , b.burden_uom
776: , b.burden_factor
777: , b.delete_mark
778: FROM
779: cm_cmpt_mst c, cm_brdn_dtl b
780: WHERE
781: b.organization_id = p_header_rec.organization_id
782: AND b.inventory_item_id = p_header_rec.inventory_item_id
783: AND b.period_id = p_header_rec.period_id

Line 823: FOR cr_rec IN cm_brdn_dtl

819: ' Calendar ' || p_header_rec.calendar_code || ' Period ' || p_header_rec.Period_code ||
820: ' Mthd ' || p_header_rec.cost_mthd_code ) ;
821: END IF;
822:
823: FOR cr_rec IN cm_brdn_dtl
824: LOOP
825: l_idx := l_idx + 1 ;
826: x_dtl_tbl(l_idx).burdenline_id := cr_rec.burdenline_id ;
827: x_dtl_tbl(l_idx).resources := cr_rec.resources ;

Line 921: p_organization_id IN cm_brdn_dtl.organization_id%TYPE,

917: -- Func end of comments
918:
919: FUNCTION check_records_exist
920: (
921: p_organization_id IN cm_brdn_dtl.organization_id%TYPE,
922: p_inventory_item_id IN cm_brdn_dtl.inventory_item_id%TYPE,
923: p_resources IN cm_brdn_dtl.resources%TYPE,
924: p_period_id IN cm_brdn_dtl.period_id%TYPE,
925: p_cost_type_id IN cm_brdn_dtl.cost_type_id%TYPE ,

Line 922: p_inventory_item_id IN cm_brdn_dtl.inventory_item_id%TYPE,

918:
919: FUNCTION check_records_exist
920: (
921: p_organization_id IN cm_brdn_dtl.organization_id%TYPE,
922: p_inventory_item_id IN cm_brdn_dtl.inventory_item_id%TYPE,
923: p_resources IN cm_brdn_dtl.resources%TYPE,
924: p_period_id IN cm_brdn_dtl.period_id%TYPE,
925: p_cost_type_id IN cm_brdn_dtl.cost_type_id%TYPE ,
926: p_cost_cmpntcls_id IN cm_brdn_dtl.cost_cmpntcls_id%TYPE,

Line 923: p_resources IN cm_brdn_dtl.resources%TYPE,

919: FUNCTION check_records_exist
920: (
921: p_organization_id IN cm_brdn_dtl.organization_id%TYPE,
922: p_inventory_item_id IN cm_brdn_dtl.inventory_item_id%TYPE,
923: p_resources IN cm_brdn_dtl.resources%TYPE,
924: p_period_id IN cm_brdn_dtl.period_id%TYPE,
925: p_cost_type_id IN cm_brdn_dtl.cost_type_id%TYPE ,
926: p_cost_cmpntcls_id IN cm_brdn_dtl.cost_cmpntcls_id%TYPE,
927: p_cost_analysis_code IN cm_brdn_dtl.cost_analysis_code%TYPE

Line 924: p_period_id IN cm_brdn_dtl.period_id%TYPE,

920: (
921: p_organization_id IN cm_brdn_dtl.organization_id%TYPE,
922: p_inventory_item_id IN cm_brdn_dtl.inventory_item_id%TYPE,
923: p_resources IN cm_brdn_dtl.resources%TYPE,
924: p_period_id IN cm_brdn_dtl.period_id%TYPE,
925: p_cost_type_id IN cm_brdn_dtl.cost_type_id%TYPE ,
926: p_cost_cmpntcls_id IN cm_brdn_dtl.cost_cmpntcls_id%TYPE,
927: p_cost_analysis_code IN cm_brdn_dtl.cost_analysis_code%TYPE
928: )

Line 925: p_cost_type_id IN cm_brdn_dtl.cost_type_id%TYPE ,

921: p_organization_id IN cm_brdn_dtl.organization_id%TYPE,
922: p_inventory_item_id IN cm_brdn_dtl.inventory_item_id%TYPE,
923: p_resources IN cm_brdn_dtl.resources%TYPE,
924: p_period_id IN cm_brdn_dtl.period_id%TYPE,
925: p_cost_type_id IN cm_brdn_dtl.cost_type_id%TYPE ,
926: p_cost_cmpntcls_id IN cm_brdn_dtl.cost_cmpntcls_id%TYPE,
927: p_cost_analysis_code IN cm_brdn_dtl.cost_analysis_code%TYPE
928: )
929: RETURN BOOLEAN

Line 926: p_cost_cmpntcls_id IN cm_brdn_dtl.cost_cmpntcls_id%TYPE,

922: p_inventory_item_id IN cm_brdn_dtl.inventory_item_id%TYPE,
923: p_resources IN cm_brdn_dtl.resources%TYPE,
924: p_period_id IN cm_brdn_dtl.period_id%TYPE,
925: p_cost_type_id IN cm_brdn_dtl.cost_type_id%TYPE ,
926: p_cost_cmpntcls_id IN cm_brdn_dtl.cost_cmpntcls_id%TYPE,
927: p_cost_analysis_code IN cm_brdn_dtl.cost_analysis_code%TYPE
928: )
929: RETURN BOOLEAN
930: IS

Line 927: p_cost_analysis_code IN cm_brdn_dtl.cost_analysis_code%TYPE

923: p_resources IN cm_brdn_dtl.resources%TYPE,
924: p_period_id IN cm_brdn_dtl.period_id%TYPE,
925: p_cost_type_id IN cm_brdn_dtl.cost_type_id%TYPE ,
926: p_cost_cmpntcls_id IN cm_brdn_dtl.cost_cmpntcls_id%TYPE,
927: p_cost_analysis_code IN cm_brdn_dtl.cost_analysis_code%TYPE
928: )
929: RETURN BOOLEAN
930: IS
931: CURSOR Cur_burden_dtl

Line 932: ( cp_organization_id cm_brdn_dtl.organization_id%TYPE,

928: )
929: RETURN BOOLEAN
930: IS
931: CURSOR Cur_burden_dtl
932: ( cp_organization_id cm_brdn_dtl.organization_id%TYPE,
933: cp_inventory_item_id cm_brdn_dtl.inventory_item_id%TYPE,
934: cp_resources cm_brdn_dtl.resources%TYPE ,
935: cp_period_id cm_brdn_dtl.period_id%TYPE,
936: cp_cost_type_id cm_brdn_dtl.cost_type_id%TYPE ,

Line 933: cp_inventory_item_id cm_brdn_dtl.inventory_item_id%TYPE,

929: RETURN BOOLEAN
930: IS
931: CURSOR Cur_burden_dtl
932: ( cp_organization_id cm_brdn_dtl.organization_id%TYPE,
933: cp_inventory_item_id cm_brdn_dtl.inventory_item_id%TYPE,
934: cp_resources cm_brdn_dtl.resources%TYPE ,
935: cp_period_id cm_brdn_dtl.period_id%TYPE,
936: cp_cost_type_id cm_brdn_dtl.cost_type_id%TYPE ,
937: cp_cost_cmpntcls_id cm_brdn_dtl.cost_cmpntcls_id%TYPE,

Line 934: cp_resources cm_brdn_dtl.resources%TYPE ,

930: IS
931: CURSOR Cur_burden_dtl
932: ( cp_organization_id cm_brdn_dtl.organization_id%TYPE,
933: cp_inventory_item_id cm_brdn_dtl.inventory_item_id%TYPE,
934: cp_resources cm_brdn_dtl.resources%TYPE ,
935: cp_period_id cm_brdn_dtl.period_id%TYPE,
936: cp_cost_type_id cm_brdn_dtl.cost_type_id%TYPE ,
937: cp_cost_cmpntcls_id cm_brdn_dtl.cost_cmpntcls_id%TYPE,
938: cp_cost_analysis_code cm_brdn_dtl.cost_analysis_code%TYPE

Line 935: cp_period_id cm_brdn_dtl.period_id%TYPE,

931: CURSOR Cur_burden_dtl
932: ( cp_organization_id cm_brdn_dtl.organization_id%TYPE,
933: cp_inventory_item_id cm_brdn_dtl.inventory_item_id%TYPE,
934: cp_resources cm_brdn_dtl.resources%TYPE ,
935: cp_period_id cm_brdn_dtl.period_id%TYPE,
936: cp_cost_type_id cm_brdn_dtl.cost_type_id%TYPE ,
937: cp_cost_cmpntcls_id cm_brdn_dtl.cost_cmpntcls_id%TYPE,
938: cp_cost_analysis_code cm_brdn_dtl.cost_analysis_code%TYPE
939: )

Line 936: cp_cost_type_id cm_brdn_dtl.cost_type_id%TYPE ,

932: ( cp_organization_id cm_brdn_dtl.organization_id%TYPE,
933: cp_inventory_item_id cm_brdn_dtl.inventory_item_id%TYPE,
934: cp_resources cm_brdn_dtl.resources%TYPE ,
935: cp_period_id cm_brdn_dtl.period_id%TYPE,
936: cp_cost_type_id cm_brdn_dtl.cost_type_id%TYPE ,
937: cp_cost_cmpntcls_id cm_brdn_dtl.cost_cmpntcls_id%TYPE,
938: cp_cost_analysis_code cm_brdn_dtl.cost_analysis_code%TYPE
939: )
940: IS

Line 937: cp_cost_cmpntcls_id cm_brdn_dtl.cost_cmpntcls_id%TYPE,

933: cp_inventory_item_id cm_brdn_dtl.inventory_item_id%TYPE,
934: cp_resources cm_brdn_dtl.resources%TYPE ,
935: cp_period_id cm_brdn_dtl.period_id%TYPE,
936: cp_cost_type_id cm_brdn_dtl.cost_type_id%TYPE ,
937: cp_cost_cmpntcls_id cm_brdn_dtl.cost_cmpntcls_id%TYPE,
938: cp_cost_analysis_code cm_brdn_dtl.cost_analysis_code%TYPE
939: )
940: IS
941: SELECT 'x'

Line 938: cp_cost_analysis_code cm_brdn_dtl.cost_analysis_code%TYPE

934: cp_resources cm_brdn_dtl.resources%TYPE ,
935: cp_period_id cm_brdn_dtl.period_id%TYPE,
936: cp_cost_type_id cm_brdn_dtl.cost_type_id%TYPE ,
937: cp_cost_cmpntcls_id cm_brdn_dtl.cost_cmpntcls_id%TYPE,
938: cp_cost_analysis_code cm_brdn_dtl.cost_analysis_code%TYPE
939: )
940: IS
941: SELECT 'x'
942: FROM cm_brdn_dtl

Line 942: FROM cm_brdn_dtl

938: cp_cost_analysis_code cm_brdn_dtl.cost_analysis_code%TYPE
939: )
940: IS
941: SELECT 'x'
942: FROM cm_brdn_dtl
943: WHERE organization_id = cp_organization_id
944: AND inventory_item_id = cp_inventory_item_id
945: AND resources = cp_resources
946: AND period_id = cp_period_id