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 4108: l_eiid_tbl pa_plsql_datatypes.IdTabTyp;

4104: err_buf varchar2(4000);--Bug 5726575
4105: ret_code varchar2(250);--Bug 5726575
4106: GMS_INSERT_ENC_ITEM_ERROR exception; --Bug 5726575
4107:
4108: l_eiid_tbl pa_plsql_datatypes.IdTabTyp;
4109: l_csid_tbl pa_plsql_datatypes.IdTabTyp;
4110: l_rowid_tbl pa_plsql_datatypes.RowidTabTyp;
4111: l_rev_inv_flag_tbl pa_plsql_datatypes.Char1TabTyp;
4112:

Line 4109: l_csid_tbl pa_plsql_datatypes.IdTabTyp;

4105: ret_code varchar2(250);--Bug 5726575
4106: GMS_INSERT_ENC_ITEM_ERROR exception; --Bug 5726575
4107:
4108: l_eiid_tbl pa_plsql_datatypes.IdTabTyp;
4109: l_csid_tbl pa_plsql_datatypes.IdTabTyp;
4110: l_rowid_tbl pa_plsql_datatypes.RowidTabTyp;
4111: l_rev_inv_flag_tbl pa_plsql_datatypes.Char1TabTyp;
4112:
4113: /* Commented for the bug 4527736

Line 4110: l_rowid_tbl pa_plsql_datatypes.RowidTabTyp;

4106: GMS_INSERT_ENC_ITEM_ERROR exception; --Bug 5726575
4107:
4108: l_eiid_tbl pa_plsql_datatypes.IdTabTyp;
4109: l_csid_tbl pa_plsql_datatypes.IdTabTyp;
4110: l_rowid_tbl pa_plsql_datatypes.RowidTabTyp;
4111: l_rev_inv_flag_tbl pa_plsql_datatypes.Char1TabTyp;
4112:
4113: /* Commented for the bug 4527736
4114: CURSOR mark_impacted_cost_bases --3054111

Line 4111: l_rev_inv_flag_tbl pa_plsql_datatypes.Char1TabTyp;

4107:
4108: l_eiid_tbl pa_plsql_datatypes.IdTabTyp;
4109: l_csid_tbl pa_plsql_datatypes.IdTabTyp;
4110: l_rowid_tbl pa_plsql_datatypes.RowidTabTyp;
4111: l_rev_inv_flag_tbl pa_plsql_datatypes.Char1TabTyp;
4112:
4113: /* Commented for the bug 4527736
4114: CURSOR mark_impacted_cost_bases --3054111
4115: IS

Line 6601: l_expenditure_item_id_tab IN PA_PLSQL_DATATYPES.IDTABTYP,

6597: inv_adj_reason IN varchar2,
6598: tp_adj_reason IN varchar2,
6599: status IN OUT NOCOPY number,
6600: stage IN OUT NOCOPY number,
6601: l_expenditure_item_id_tab IN PA_PLSQL_DATATYPES.IDTABTYP,
6602: l_adj_tyep_tab IN PA_PLSQL_DATATYPES.Char30TabTyp)
6603: */
6604: procedure add_adjustment_activity( l_expenditure_item_id_tab IN PA_PLSQL_DATATYPES.IDTABTYP
6605: ,l_adj_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp

Line 6602: l_adj_tyep_tab IN PA_PLSQL_DATATYPES.Char30TabTyp)

6598: tp_adj_reason IN varchar2,
6599: status IN OUT NOCOPY number,
6600: stage IN OUT NOCOPY number,
6601: l_expenditure_item_id_tab IN PA_PLSQL_DATATYPES.IDTABTYP,
6602: l_adj_tyep_tab IN PA_PLSQL_DATATYPES.Char30TabTyp)
6603: */
6604: procedure add_adjustment_activity( l_expenditure_item_id_tab IN PA_PLSQL_DATATYPES.IDTABTYP
6605: ,l_adj_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp
6606: ,status IN OUT NOCOPY number

Line 6604: procedure add_adjustment_activity( l_expenditure_item_id_tab IN PA_PLSQL_DATATYPES.IDTABTYP

6600: stage IN OUT NOCOPY number,
6601: l_expenditure_item_id_tab IN PA_PLSQL_DATATYPES.IDTABTYP,
6602: l_adj_tyep_tab IN PA_PLSQL_DATATYPES.Char30TabTyp)
6603: */
6604: procedure add_adjustment_activity( l_expenditure_item_id_tab IN PA_PLSQL_DATATYPES.IDTABTYP
6605: ,l_adj_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp
6606: ,status IN OUT NOCOPY number
6607: ,stage IN OUT NOCOPY number
6608: )

Line 6605: ,l_adj_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp

6601: l_expenditure_item_id_tab IN PA_PLSQL_DATATYPES.IDTABTYP,
6602: l_adj_tyep_tab IN PA_PLSQL_DATATYPES.Char30TabTyp)
6603: */
6604: procedure add_adjustment_activity( l_expenditure_item_id_tab IN PA_PLSQL_DATATYPES.IDTABTYP
6605: ,l_adj_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp
6606: ,status IN OUT NOCOPY number
6607: ,stage IN OUT NOCOPY number
6608: )
6609: IS

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

6690: x_last_updated_by NUMBER(15);
6691: x_last_update_login NUMBER(15);
6692: x_program_application_id NUMBER(15);
6693: x_program_id NUMBER(15);
6694: -- l_eid_tbl PA_PLSQL_DATATYPES.IdTabTyp; /*3040724*/
6695: l_limit_size NUMBER :=500 ; /*3040724*/
6696:
6697: BEGIN
6698: