DBA Data[Home] [Help]

APPS.PA_COST_PLUS dependencies on PA_PLSQL_DATATYPES

Line 24: G_IMPACTED_COST_BASES_TAB PA_PLSQL_DATATYPES.Char30TabTyp;

20: G_CP_STRUCTURE PA_COST_PLUS_STRUCTURES.COST_PLUS_STRUCTURE%TYPE;
21: G_ORG_STRUC_VER_ID PA_IND_RATE_SCH_REVISIONS.ORG_STRUCTURE_VERSION_ID%TYPE;
22: G_START_ORGANIZATION_ID PA_IND_RATE_SCH_REVISIONS.START_ORGANIZATION_ID%TYPE;
23:
24: G_IMPACTED_COST_BASES_TAB PA_PLSQL_DATATYPES.Char30TabTyp;
25: G_EXPENDITURE_ITEM_ID_TAB PA_PLSQL_DATATYPES.IDTABTYP;
26: G_ADJ_TYPE_TAB PA_PLSQL_DATATYPES.Char30TabTyp;
27:
28: /*

Line 25: G_EXPENDITURE_ITEM_ID_TAB PA_PLSQL_DATATYPES.IDTABTYP;

21: G_ORG_STRUC_VER_ID PA_IND_RATE_SCH_REVISIONS.ORG_STRUCTURE_VERSION_ID%TYPE;
22: G_START_ORGANIZATION_ID PA_IND_RATE_SCH_REVISIONS.START_ORGANIZATION_ID%TYPE;
23:
24: G_IMPACTED_COST_BASES_TAB PA_PLSQL_DATATYPES.Char30TabTyp;
25: G_EXPENDITURE_ITEM_ID_TAB PA_PLSQL_DATATYPES.IDTABTYP;
26: G_ADJ_TYPE_TAB PA_PLSQL_DATATYPES.Char30TabTyp;
27:
28: /*
29: * Private Procedure.

Line 26: G_ADJ_TYPE_TAB PA_PLSQL_DATATYPES.Char30TabTyp;

22: G_START_ORGANIZATION_ID PA_IND_RATE_SCH_REVISIONS.START_ORGANIZATION_ID%TYPE;
23:
24: G_IMPACTED_COST_BASES_TAB PA_PLSQL_DATATYPES.Char30TabTyp;
25: G_EXPENDITURE_ITEM_ID_TAB PA_PLSQL_DATATYPES.IDTABTYP;
26: G_ADJ_TYPE_TAB PA_PLSQL_DATATYPES.Char30TabTyp;
27:
28: /*
29: * Private Procedure.
30: */

Line 4078: l_eiid_tbl pa_plsql_datatypes.IdTabTyp;

4074: err_buf varchar2(4000);--Bug 5726575
4075: ret_code varchar2(250);--Bug 5726575
4076: GMS_INSERT_ENC_ITEM_ERROR exception; --Bug 5726575
4077:
4078: l_eiid_tbl pa_plsql_datatypes.IdTabTyp;
4079: l_csid_tbl pa_plsql_datatypes.IdTabTyp;
4080: l_rowid_tbl pa_plsql_datatypes.RowidTabTyp;
4081: l_rev_inv_flag_tbl pa_plsql_datatypes.Char1TabTyp;
4082:

Line 4079: l_csid_tbl pa_plsql_datatypes.IdTabTyp;

4075: ret_code varchar2(250);--Bug 5726575
4076: GMS_INSERT_ENC_ITEM_ERROR exception; --Bug 5726575
4077:
4078: l_eiid_tbl pa_plsql_datatypes.IdTabTyp;
4079: l_csid_tbl pa_plsql_datatypes.IdTabTyp;
4080: l_rowid_tbl pa_plsql_datatypes.RowidTabTyp;
4081: l_rev_inv_flag_tbl pa_plsql_datatypes.Char1TabTyp;
4082:
4083: /* Commented for the bug 4527736

Line 4080: l_rowid_tbl pa_plsql_datatypes.RowidTabTyp;

4076: GMS_INSERT_ENC_ITEM_ERROR exception; --Bug 5726575
4077:
4078: l_eiid_tbl pa_plsql_datatypes.IdTabTyp;
4079: l_csid_tbl pa_plsql_datatypes.IdTabTyp;
4080: l_rowid_tbl pa_plsql_datatypes.RowidTabTyp;
4081: l_rev_inv_flag_tbl pa_plsql_datatypes.Char1TabTyp;
4082:
4083: /* Commented for the bug 4527736
4084: CURSOR mark_impacted_cost_bases --3054111

Line 4081: l_rev_inv_flag_tbl pa_plsql_datatypes.Char1TabTyp;

4077:
4078: l_eiid_tbl pa_plsql_datatypes.IdTabTyp;
4079: l_csid_tbl pa_plsql_datatypes.IdTabTyp;
4080: l_rowid_tbl pa_plsql_datatypes.RowidTabTyp;
4081: l_rev_inv_flag_tbl pa_plsql_datatypes.Char1TabTyp;
4082:
4083: /* Commented for the bug 4527736
4084: CURSOR mark_impacted_cost_bases --3054111
4085: IS

Line 6374: l_expenditure_item_id_tab IN PA_PLSQL_DATATYPES.IDTABTYP,

6370: inv_adj_reason IN varchar2,
6371: tp_adj_reason IN varchar2,
6372: status IN OUT NOCOPY number,
6373: stage IN OUT NOCOPY number,
6374: l_expenditure_item_id_tab IN PA_PLSQL_DATATYPES.IDTABTYP,
6375: l_adj_tyep_tab IN PA_PLSQL_DATATYPES.Char30TabTyp)
6376: */
6377: procedure add_adjustment_activity( l_expenditure_item_id_tab IN PA_PLSQL_DATATYPES.IDTABTYP
6378: ,l_adj_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp

Line 6375: l_adj_tyep_tab IN PA_PLSQL_DATATYPES.Char30TabTyp)

6371: tp_adj_reason IN varchar2,
6372: status IN OUT NOCOPY number,
6373: stage IN OUT NOCOPY number,
6374: l_expenditure_item_id_tab IN PA_PLSQL_DATATYPES.IDTABTYP,
6375: l_adj_tyep_tab IN PA_PLSQL_DATATYPES.Char30TabTyp)
6376: */
6377: procedure add_adjustment_activity( l_expenditure_item_id_tab IN PA_PLSQL_DATATYPES.IDTABTYP
6378: ,l_adj_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp
6379: ,status IN OUT NOCOPY number

Line 6377: procedure add_adjustment_activity( l_expenditure_item_id_tab IN PA_PLSQL_DATATYPES.IDTABTYP

6373: stage IN OUT NOCOPY number,
6374: l_expenditure_item_id_tab IN PA_PLSQL_DATATYPES.IDTABTYP,
6375: l_adj_tyep_tab IN PA_PLSQL_DATATYPES.Char30TabTyp)
6376: */
6377: procedure add_adjustment_activity( l_expenditure_item_id_tab IN PA_PLSQL_DATATYPES.IDTABTYP
6378: ,l_adj_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp
6379: ,status IN OUT NOCOPY number
6380: ,stage IN OUT NOCOPY number
6381: )

Line 6378: ,l_adj_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp

6374: l_expenditure_item_id_tab IN PA_PLSQL_DATATYPES.IDTABTYP,
6375: l_adj_tyep_tab IN PA_PLSQL_DATATYPES.Char30TabTyp)
6376: */
6377: procedure add_adjustment_activity( l_expenditure_item_id_tab IN PA_PLSQL_DATATYPES.IDTABTYP
6378: ,l_adj_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp
6379: ,status IN OUT NOCOPY number
6380: ,stage IN OUT NOCOPY number
6381: )
6382: IS

Line 6467: -- l_eid_tbl PA_PLSQL_DATATYPES.IdTabTyp; /*3040724*/

6463: x_last_updated_by NUMBER(15);
6464: x_last_update_login NUMBER(15);
6465: x_program_application_id NUMBER(15);
6466: x_program_id NUMBER(15);
6467: -- l_eid_tbl PA_PLSQL_DATATYPES.IdTabTyp; /*3040724*/
6468: l_limit_size NUMBER :=500 ; /*3040724*/
6469:
6470: BEGIN
6471: