DBA Data[Home] [Help]

APPS.PA_RP_UTIL dependencies on PA_RP_DEFINITIONS_B

Line 80: PA_RP_Definitions_B rp, PA_RP_Template_Lists templates, XDO_LOBS xdo

76:
77: SELECT COUNT(*)
78: INTO l_count
79: FROM
80: PA_RP_Definitions_B rp, PA_RP_Template_Lists templates, XDO_LOBS xdo
81: WHERE rp.rp_Id = p_rp_id
82: AND rp.rp_Id = templates.rp_Id
83: AND templates.template_code = xdo.LOB_CODE
84: AND xdo.application_short_name = p_app_short_name

Line 93: PA_RP_Definitions_B rp, PA_RP_TYPES_b TYPES, XDO_LOBS xdo

89: IF l_count = 0 THEN
90: SELECT COUNT(*)
91: INTO l_count
92: FROM
93: PA_RP_Definitions_B rp, PA_RP_TYPES_b TYPES, XDO_LOBS xdo
94: WHERE rp.rp_Id = p_rp_id
95: AND rp.rp_type_Id = types.rp_type_Id
96: AND types.seeded_dt_code = xdo.LOB_CODE
97: AND xdo.application_short_name = p_app_short_name

Line 133: UPDATE PA_RP_DEFINITIONS_B

129: x_msg_count := 0;
130: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
131: END IF;
132:
133: UPDATE PA_RP_DEFINITIONS_B
134: SET dt_process_date = SYSDATE
135: WHERE rp_id = p_rp_id;
136:
137: SELECT RP_FILE_DATA

Line 150: FROM PA_RP_DEFINITIONS_B

146: WHERE rp_id = p_rp_id;
147: /*
148: SELECT trimmed_dt
149: INTO x_trimmed_dt
150: FROM PA_RP_DEFINITIONS_B
151: WHERE rp_id = p_rp_id
152: FOR UPDATE;
153: */
154: IF g_debug_mode = 'Y' THEN