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 128: INTO GMF_PROCESS_ORGANIZATIONS_GT

124: END LOOP;
125:
126: FORALL j IN 1..l_le_info.COUNT
127: INSERT
128: INTO GMF_PROCESS_ORGANIZATIONS_GT
129: (
130: organization_id,
131: organization_code,
132: base_currency_code,

Line 170: UPDATE gmf_process_organizations_gt gpo

166: RETURN;
167: END IF;
168:
169:
170: UPDATE gmf_process_organizations_gt gpo
171: SET std_uom = (SELECT u.uom_code
172: FROM mtl_units_of_measure u,
173: gmd_parameters_hdr h,
174: gmd_parameters_dtl d

Line 182: UPDATE gmf_process_organizations_gt gpo

178: AND d.parameter_name = 'FM_YIELD_TYPE'
179: AND d.parameter_value = u.uom_class)
180: WHERE gpo.std_uom IS NULL;
181:
182: UPDATE gmf_process_organizations_gt gpo
183: SET std_uom = (SELECT u.uom_code
184: FROM mtl_units_of_measure u,
185: gmd_parameters_hdr h,
186: gmd_parameters_dtl d