DBA Data[Home] [Help]

APPS.RCV_TABLE_FUNCTIONS dependencies on MTL_PARAMETERS

Line 19: g_mp_row mtl_parameters%ROWTYPE;

15: g_prl_row po_requisition_lines_all%ROWTYPE;
16: g_prd_row po_req_distributions_all%ROWTYPE;
17: g_msi_row mtl_system_items%ROWTYPE;
18: g_mic_row mtl_item_categories%ROWTYPE;
19: g_mp_row mtl_parameters%ROWTYPE;
20: g_rp_row rcv_parameters%ROWTYPE;
21: g_fc_row fnd_currencies%ROWTYPE;
22: g_sob_row gl_sets_of_books%ROWTYPE;
23: g_fsp_row financials_system_parameters%ROWTYPE;

Line 1029: FUNCTION get_mp_row_from_org( p_org_id IN mtl_parameters.organization_id%TYPE )

1025: WHEN OTHERS THEN
1026: invalid_value(p_item_id, 'ITEM_ID');
1027: END get_mic_row_from_num;
1028:
1029: FUNCTION get_mp_row_from_org( p_org_id IN mtl_parameters.organization_id%TYPE )
1030: RETURN mtl_parameters%ROWTYPE IS
1031: BEGIN
1032: IF ( p_org_id IS NULL ) THEN
1033: RETURN NULL;

Line 1030: RETURN mtl_parameters%ROWTYPE IS

1026: invalid_value(p_item_id, 'ITEM_ID');
1027: END get_mic_row_from_num;
1028:
1029: FUNCTION get_mp_row_from_org( p_org_id IN mtl_parameters.organization_id%TYPE )
1030: RETURN mtl_parameters%ROWTYPE IS
1031: BEGIN
1032: IF ( p_org_id IS NULL ) THEN
1033: RETURN NULL;
1034: END IF;

Line 1042: FROM mtl_parameters

1038: END IF;
1039:
1040: SELECT *
1041: INTO g_mp_row
1042: FROM mtl_parameters
1043: WHERE organization_id = p_org_id
1044: AND rownum = 1;
1045:
1046: RETURN g_mp_row;

Line 1202: FROM mtl_parameters

1198: BEGIN
1199: IF ( nvl(g_mp_org_id,-99) <> p_organization_id) THEN
1200: SELECT nvl(lcm_enabled_flag,'N')
1201: INTO g_lcm_enabled_flag
1202: FROM mtl_parameters
1203: WHERE organization_id = p_organization_id;
1204:
1205: g_mp_org_id := p_organization_id;
1206: END IF;