DBA Data[Home] [Help]

APPS.PA_FP_GEN_BUDGET_AMT_PUB dependencies on PA_PLSQL_DATATYPES

Line 38: P_CI_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,

34: P_INC_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
35: P_INC_BILL_EVENT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,
36: P_INC_OPEN_COMMIT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
37: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE DEFAULT NULL,
38: P_CI_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
39: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
40: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
41: P_COMMIT_FLAG IN VARCHAR2,
42: P_INIT_MSG_FLAG IN VARCHAR2,

Line 39: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

35: P_INC_BILL_EVENT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,
36: P_INC_OPEN_COMMIT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
37: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE DEFAULT NULL,
38: P_CI_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
39: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
40: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
41: P_COMMIT_FLAG IN VARCHAR2,
42: P_INIT_MSG_FLAG IN VARCHAR2,
43: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 40: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

36: P_INC_OPEN_COMMIT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
37: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE DEFAULT NULL,
38: P_CI_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
39: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
40: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
41: P_COMMIT_FLAG IN VARCHAR2,
42: P_INIT_MSG_FLAG IN VARCHAR2,
43: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
44: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 73: PX_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

69:
70: PROCEDURE DEL_MANUAL_BDGT_LINES
71: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
72: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
73: PX_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
74: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
75: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
76: X_MSG_COUNT OUT NOCOPY NUMBER,
77: X_MSG_DATA OUT NOCOPY VARCHAR2);

Line 74: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

70: PROCEDURE DEL_MANUAL_BDGT_LINES
71: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
72: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
73: PX_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
74: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
75: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
76: X_MSG_COUNT OUT NOCOPY NUMBER,
77: X_MSG_DATA OUT NOCOPY VARCHAR2);
78:

Line 82: P_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,

78:
79: PROCEDURE UPDATE_INIT_AMOUNTS
80: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
81: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
82: P_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
83: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
84: X_MSG_COUNT OUT NOCOPY NUMBER,
85: X_MSG_DATA OUT NOCOPY VARCHAR2);
86:

Line 102: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

98:
99: PROCEDURE GET_GENERATED_RES_ASG
100: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
101: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
102: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
103: P_CHK_DUPLICATE_FLAG IN VARCHAR2 := 'N',
104: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
105: X_MSG_COUNT OUT NOCOPY NUMBER,
106: X_MSG_DATA OUT NOCOPY VARCHAR2);

Line 136: P_CI_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,

132: P_INC_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
133: P_INC_BILL_EVENT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,
134: P_INC_OPEN_COMMIT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
135: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE DEFAULT NULL,
136: P_CI_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
137: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
138: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
139: P_COMMIT_FLAG IN VARCHAR2,
140: P_INIT_MSG_FLAG IN VARCHAR2,

Line 137: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

133: P_INC_BILL_EVENT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,
134: P_INC_OPEN_COMMIT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
135: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE DEFAULT NULL,
136: P_CI_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
137: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
138: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
139: P_COMMIT_FLAG IN VARCHAR2,
140: P_INIT_MSG_FLAG IN VARCHAR2,
141: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 138: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

134: P_INC_OPEN_COMMIT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
135: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE DEFAULT NULL,
136: P_CI_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
137: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
138: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
139: P_COMMIT_FLAG IN VARCHAR2,
140: P_INIT_MSG_FLAG IN VARCHAR2,
141: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
142: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 160: P_CI_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp

156: P_CALLED_MODE IN VARCHAR2 default 'SELF_SERVICE',
157: P_INC_CHG_DOC_FLAG IN VARCHAR2 default 'N',
158: P_INC_BILL_EVENT_FLAG IN VARCHAR2 default 'N',
159: P_INC_OPEN_COMMIT_FLAG IN VARCHAR2 default 'N',
160: P_CI_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp
161: default PA_PLSQL_DATATYPES.EmptyIdTab,
162: P_INIT_MSG_FLAG IN VARCHAR2 default 'Y',
163: P_COMMIT_FLAG IN VARCHAR2 default 'N',
164: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

Line 161: default PA_PLSQL_DATATYPES.EmptyIdTab,

157: P_INC_CHG_DOC_FLAG IN VARCHAR2 default 'N',
158: P_INC_BILL_EVENT_FLAG IN VARCHAR2 default 'N',
159: P_INC_OPEN_COMMIT_FLAG IN VARCHAR2 default 'N',
160: P_CI_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp
161: default PA_PLSQL_DATATYPES.EmptyIdTab,
162: P_INIT_MSG_FLAG IN VARCHAR2 default 'Y',
163: P_COMMIT_FLAG IN VARCHAR2 default 'N',
164: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
165: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

Line 164: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

160: P_CI_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp
161: default PA_PLSQL_DATATYPES.EmptyIdTab,
162: P_INIT_MSG_FLAG IN VARCHAR2 default 'Y',
163: P_COMMIT_FLAG IN VARCHAR2 default 'N',
164: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
165: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
166: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
167: X_MSG_COUNT OUT NOCOPY NUMBER,
168: X_MSG_DATA OUT NOCOPY VARCHAR2);

Line 165: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

161: default PA_PLSQL_DATATYPES.EmptyIdTab,
162: P_INIT_MSG_FLAG IN VARCHAR2 default 'Y',
163: P_COMMIT_FLAG IN VARCHAR2 default 'N',
164: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
165: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
166: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
167: X_MSG_COUNT OUT NOCOPY NUMBER,
168: X_MSG_DATA OUT NOCOPY VARCHAR2);
169: