DBA Data[Home] [Help]

APPS.HZ_EXTRACT_ORGANIZATION_BO_PVT dependencies on HZ_FINANCIAL_BO

Line 50: x_financial_report_objs OUT NOCOPY HZ_FINANCIAL_BO_TBL,

46: procedure get_financial_report_bos(
47: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
48: p_organization_id IN NUMBER,
49: p_action_type IN VARCHAR2 := NULL,
50: x_financial_report_objs OUT NOCOPY HZ_FINANCIAL_BO_TBL,
51: x_return_status OUT NOCOPY VARCHAR2,
52: x_msg_count OUT NOCOPY NUMBER,
53: x_msg_data OUT NOCOPY VARCHAR2
54: ) is

Line 56: SELECT HZ_FINANCIAL_BO(

52: x_msg_count OUT NOCOPY NUMBER,
53: x_msg_data OUT NOCOPY VARCHAR2
54: ) is
55: CURSOR C1 IS
56: SELECT HZ_FINANCIAL_BO(
57: P_ACTION_TYPE,
58: NULL, -- COMMON_OBJ_ID
59: FINANCIAL_REPORT_ID,
60: PARTY_ID,

Line 134: x_financial_report_objs := HZ_FINANCIAL_BO_TBL();

130: p_prefix=>l_debug_prefix,
131: p_msg_level=>fnd_log.level_procedure);
132: END IF;
133:
134: x_financial_report_objs := HZ_FINANCIAL_BO_TBL();
135: open c1;
136: fetch c1 BULK COLLECT into x_financial_report_objs;
137: close c1;
138:

Line 488: HZ_FINANCIAL_BO_TBL(),

484: RANK)
485: FROM HZ_CODE_ASSIGNMENTS
486: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
487: AND OWNER_TABLE_ID = P_ORGANIZATION_ID) AS HZ_CODE_ASSIGNMENT_OBJ_TBL),
488: HZ_FINANCIAL_BO_TBL(),
489: CAST(MULTISET (
490: SELECT HZ_CREDIT_RATING_OBJ(
491: P_ACTION_TYPE,
492: NULL, -- COMMON_OBJ_ID