DBA Data[Home] [Help]

APPS.RCV_TABLE_FUNCTIONS dependencies on RCV_PARAMETERS

Line 20: g_rp_row rcv_parameters%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;
24: g_fspa_row financials_system_params_all%ROWTYPE;

Line 1025: FUNCTION get_rp_row_from_org( p_org_id IN rcv_parameters.organization_id%TYPE )

1021: WHEN OTHERS THEN
1022: invalid_value(p_org_id, 'ORG_ID');
1023: END get_mp_row_from_org;
1024:
1025: FUNCTION get_rp_row_from_org( p_org_id IN rcv_parameters.organization_id%TYPE )
1026: RETURN rcv_parameters%ROWTYPE IS
1027: BEGIN
1028: IF ( p_org_id IS NULL ) THEN
1029: RETURN NULL;

Line 1026: RETURN rcv_parameters%ROWTYPE IS

1022: invalid_value(p_org_id, 'ORG_ID');
1023: END get_mp_row_from_org;
1024:
1025: FUNCTION get_rp_row_from_org( p_org_id IN rcv_parameters.organization_id%TYPE )
1026: RETURN rcv_parameters%ROWTYPE IS
1027: BEGIN
1028: IF ( p_org_id IS NULL ) THEN
1029: RETURN NULL;
1030: END IF;

Line 1038: FROM rcv_parameters

1034: END IF;
1035:
1036: SELECT *
1037: INTO g_rp_row
1038: FROM rcv_parameters
1039: WHERE organization_id = p_org_id
1040: AND rownum = 1;
1041:
1042: RETURN g_rp_row;

Line 1184: FROM rcv_parameters

1180: BEGIN
1181: IF ( nvl(g_rp_org_id,-99) <> p_organization_id) THEN
1182: SELECT nvl(pre_receive,'N')
1183: INTO g_pre_rcv_flag
1184: FROM rcv_parameters
1185: WHERE organization_id = p_organization_id;
1186:
1187: g_rp_org_id := p_organization_id;
1188: END IF;