APPS.GMF_ORGANIZATIONS_PKG dependencies on GMF_PERIOD_STATUSES

Line 41: l_period_id gmf_period_statuses.period_id%TYPE; /* B8757676 */

37: x_Row_Count OUT NOCOPY NUMBER,
38: x_Return_Status OUT NOCOPY NUMBER)
39:
40: IS
41: l_period_id gmf_period_statuses.period_id%TYPE; /* B8757676 */
42: l_period_start_date gmf_period_statuses.start_date%TYPE; /* B8757676 */
43: l_period_end_date gmf_period_statuses.end_date%TYPE; /* B8757676 */
44:
45: BEGIN /* B8757676 */

Line 42: l_period_start_date gmf_period_statuses.start_date%TYPE; /* B8757676 */

38: x_Return_Status OUT NOCOPY NUMBER)
39:
40: IS
41: l_period_id gmf_period_statuses.period_id%TYPE; /* B8757676 */
42: l_period_start_date gmf_period_statuses.start_date%TYPE; /* B8757676 */
43: l_period_end_date gmf_period_statuses.end_date%TYPE; /* B8757676 */
44:
45: BEGIN /* B8757676 */
46: l_period_id := p_period_id;

Line 43: l_period_end_date gmf_period_statuses.end_date%TYPE; /* B8757676 */

39:
40: IS
41: l_period_id gmf_period_statuses.period_id%TYPE; /* B8757676 */
42: l_period_start_date gmf_period_statuses.start_date%TYPE; /* B8757676 */
43: l_period_end_date gmf_period_statuses.end_date%TYPE; /* B8757676 */
44:
45: BEGIN /* B8757676 */
46: l_period_id := p_period_id;
47: l_period_start_date := NULL; /*Bug10096240*/

Line 54: FROM gmf_period_statuses WHERE period_id = l_period_id ;

50: BEGIN
51: IF l_period_id IS NOT NULL THEN
52: SELECT start_date, end_date INTO
53: l_period_start_date, l_period_end_date
54: FROM gmf_period_statuses WHERE period_id = l_period_id ;
55: ELSE
56: NULL;
57: END IF;
58:

Line 95: l_period_end_date gmf_period_statuses.end_date%TYPE; /* B10048030 */

91: l_le_info XLE_BUSINESSINFO_GRP.INV_ORG_REC_TYPE;
92:
93: TYPE inv_orgs IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
94: l_inv_orgs inv_orgs;
95: l_period_end_date gmf_period_statuses.end_date%TYPE; /* B10048030 */
96:
97: BEGIN
98:
99: x_Return_Status := 0;