APPS.PA_PERIOD_PROCESS_PKG dependencies on PA_PLSQL_DATATYPES

Line 118: l_PeriodTab PA_PLSQL_DATATYPES.Char15TabTyp;

114: and a.start_date = b.start_date
115: and a.end_Date = b.end_date
116: and a.status <> b.closing_status;
117:
118: l_PeriodTab PA_PLSQL_DATATYPES.Char15TabTyp;
119: l_StatusTab PA_PLSQL_DATATYPES.Char1TabTyp;
120: l_SobId PA_PLSQL_DATATYPES.IdTabTyp;
121: l_LastUpdateDate PA_PLSQL_DATATYPES.DateTabTyp; /* added bug 3111150 */
122: l_LastUpdatedBy PA_PLSQL_DATATYPES.IdTabTyp; /* added bug 3111150 */

Line 119: l_StatusTab PA_PLSQL_DATATYPES.Char1TabTyp;

115: and a.end_Date = b.end_date
116: and a.status <> b.closing_status;
117:
118: l_PeriodTab PA_PLSQL_DATATYPES.Char15TabTyp;
119: l_StatusTab PA_PLSQL_DATATYPES.Char1TabTyp;
120: l_SobId PA_PLSQL_DATATYPES.IdTabTyp;
121: l_LastUpdateDate PA_PLSQL_DATATYPES.DateTabTyp; /* added bug 3111150 */
122: l_LastUpdatedBy PA_PLSQL_DATATYPES.IdTabTyp; /* added bug 3111150 */
123: l_LastUpdateLogin PA_PLSQL_DATATYPES.IdTabTyp; /* added bug 3111150 */

Line 120: l_SobId PA_PLSQL_DATATYPES.IdTabTyp;

116: and a.status <> b.closing_status;
117:
118: l_PeriodTab PA_PLSQL_DATATYPES.Char15TabTyp;
119: l_StatusTab PA_PLSQL_DATATYPES.Char1TabTyp;
120: l_SobId PA_PLSQL_DATATYPES.IdTabTyp;
121: l_LastUpdateDate PA_PLSQL_DATATYPES.DateTabTyp; /* added bug 3111150 */
122: l_LastUpdatedBy PA_PLSQL_DATATYPES.IdTabTyp; /* added bug 3111150 */
123: l_LastUpdateLogin PA_PLSQL_DATATYPES.IdTabTyp; /* added bug 3111150 */
124:

Line 121: l_LastUpdateDate PA_PLSQL_DATATYPES.DateTabTyp; /* added bug 3111150 */

117:
118: l_PeriodTab PA_PLSQL_DATATYPES.Char15TabTyp;
119: l_StatusTab PA_PLSQL_DATATYPES.Char1TabTyp;
120: l_SobId PA_PLSQL_DATATYPES.IdTabTyp;
121: l_LastUpdateDate PA_PLSQL_DATATYPES.DateTabTyp; /* added bug 3111150 */
122: l_LastUpdatedBy PA_PLSQL_DATATYPES.IdTabTyp; /* added bug 3111150 */
123: l_LastUpdateLogin PA_PLSQL_DATATYPES.IdTabTyp; /* added bug 3111150 */
124:
125: begin

Line 122: l_LastUpdatedBy PA_PLSQL_DATATYPES.IdTabTyp; /* added bug 3111150 */

118: l_PeriodTab PA_PLSQL_DATATYPES.Char15TabTyp;
119: l_StatusTab PA_PLSQL_DATATYPES.Char1TabTyp;
120: l_SobId PA_PLSQL_DATATYPES.IdTabTyp;
121: l_LastUpdateDate PA_PLSQL_DATATYPES.DateTabTyp; /* added bug 3111150 */
122: l_LastUpdatedBy PA_PLSQL_DATATYPES.IdTabTyp; /* added bug 3111150 */
123: l_LastUpdateLogin PA_PLSQL_DATATYPES.IdTabTyp; /* added bug 3111150 */
124:
125: begin
126: open c_periods;

Line 123: l_LastUpdateLogin PA_PLSQL_DATATYPES.IdTabTyp; /* added bug 3111150 */

119: l_StatusTab PA_PLSQL_DATATYPES.Char1TabTyp;
120: l_SobId PA_PLSQL_DATATYPES.IdTabTyp;
121: l_LastUpdateDate PA_PLSQL_DATATYPES.DateTabTyp; /* added bug 3111150 */
122: l_LastUpdatedBy PA_PLSQL_DATATYPES.IdTabTyp; /* added bug 3111150 */
123: l_LastUpdateLogin PA_PLSQL_DATATYPES.IdTabTyp; /* added bug 3111150 */
124:
125: begin
126: open c_periods;
127: loop