APPS.GMF_ORGANIZATIONS_PKG dependencies on GMF_PROCESS_ORGANIZATIONS_GT

Line 24: --| GMF_PROCESS_ORGANIZATIONS_GT with process organization for a |

20: --| |
21: --|AUTHOR : Sukarna Reddy Dt 05-Jul-2005 |
22: --| Notes |
23: --| This package contains a procedure to populate global temporary table |
24: --| GMF_PROCESS_ORGANIZATIONS_GT with process organization for a |
25: --| specified legal entity. |
26: --| |
27: --| HISTORY |
28: --| umoogala 05-Aug-2005 Added Legal_entity_Id to the table. |

Line 80: INTO GMF_PROCESS_ORGANIZATIONS_GT

76: END LOOP;
77:
78: FORALL j IN 1..l_le_info.COUNT
79: INSERT
80: INTO GMF_PROCESS_ORGANIZATIONS_GT
81: (
82: organization_id,
83: organization_code,
84: base_currency_code,

Line 115: UPDATE gmf_process_organizations_gt gpo

111: RETURN;
112: END IF;
113:
114:
115: UPDATE gmf_process_organizations_gt gpo
116: SET std_uom = (SELECT u.uom_code
117: FROM mtl_units_of_measure u,
118: gmd_parameters_hdr h,
119: gmd_parameters_dtl d

Line 127: UPDATE gmf_process_organizations_gt gpo

123: AND d.parameter_name = 'FM_YIELD_TYPE'
124: AND d.parameter_value = u.uom_class)
125: WHERE gpo.std_uom IS NULL;
126:
127: UPDATE gmf_process_organizations_gt gpo
128: SET std_uom = (SELECT u.uom_code
129: FROM mtl_units_of_measure u,
130: gmd_parameters_hdr h,
131: gmd_parameters_dtl d