APPS.PA_COST_PLUS dependencies on PA_COST_PLUS_STRUCTURES

Line 20: G_CP_STRUCTURE PA_COST_PLUS_STRUCTURES.COST_PLUS_STRUCTURE%TYPE;

16: */
17:
18: /*Added these variables for the bug 4527736*/
19: G_RATE_SCH_REVISION_ID PA_IND_RATE_SCH_REVISIONS.IND_RATE_SCH_REVISION_ID%TYPE ;
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;

Line 32: ,P_Cp_Structure IN PA_COST_PLUS_STRUCTURES.COST_PLUS_STRUCTURE%TYPE

28: /*
29: * Private Procedure.
30: */
31: PROCEDURE Cache_Impacted_Cost_Bases ( P_Ind_Rate_Sch_Revision_Id IN PA_IND_RATE_SCH_REVISIONS.IND_RATE_SCH_REVISION_ID%TYPE
32: ,P_Cp_Structure IN PA_COST_PLUS_STRUCTURES.COST_PLUS_STRUCTURE%TYPE
33: );
34: /* End Bug# 4527736 */
35:
36: G_gms_enabled varchar2(1):= gms_pa_api3.grants_enabled ;

Line 1219: l_cp_structure pa_cost_plus_structures.cost_plus_structure%TYPE ; /*3055700*/

1215: rate_sch_rev_id number;
1216: org_tab org_tab_type; /*2933915*/ /*To store top impacted orgs*/
1217: lstatus number ; /*2933915*/
1218: l_check number ; /*3055700*/
1219: l_cp_structure pa_cost_plus_structures.cost_plus_structure%TYPE ; /*3055700*/
1220: -- Standard who
1221: x_last_updated_by NUMBER(15);
1222: x_last_update_login NUMBER(15);
1223: x_request_id NUMBER(15);

Line 3985: FROM pa_cost_plus_structures

3981: x_last_update_login := FND_GLOBAL.LOGIN_ID;
3982:
3983: SELECT cost_plus_structure_type
3984: INTO structure_type
3985: FROM pa_cost_plus_structures
3986: WHERE cost_plus_structure = destination;
3987:
3988: if (structure_type = 'A') then
3989: icc_precedence := 1 ;

Line 6594: ,p_cost_plus_structure IN pa_cost_plus_structures.cost_plus_structure%TYPE,

6590:
6591: /*
6592: procedure add_adjustment_activity(compiled_set_id IN number,
6593: p_cost_base IN pa_cost_bases.cost_base%TYPE
6594: ,p_cost_plus_structure IN pa_cost_plus_structures.cost_plus_structure%TYPE,
6595: cost_adj_reason IN varchar2,
6596: rev_adj_reason IN varchar2,
6597: inv_adj_reason IN varchar2,
6598: tp_adj_reason IN varchar2,

Line 7798: ,P_Cp_Structure IN PA_COST_PLUS_STRUCTURES.COST_PLUS_STRUCTURE%TYPE

7794: RAISE;
7795: END check_for_explicit_multiplier ; /*3012681*/
7796:
7797: PROCEDURE Cache_Impacted_Cost_Bases ( P_Ind_Rate_Sch_Revision_Id IN PA_IND_RATE_SCH_REVISIONS.IND_RATE_SCH_REVISION_ID%TYPE
7798: ,P_Cp_Structure IN PA_COST_PLUS_STRUCTURES.COST_PLUS_STRUCTURE%TYPE
7799: )
7800: IS
7801: CURSOR impacted_cost_bases_cur( P_Ind_Rate_Sch_Revision_Id PA_IND_RATE_SCH_REVISIONS.IND_RATE_SCH_REVISION_ID%TYPE
7802: ,P_Cp_Structure PA_COST_PLUS_STRUCTURES.COST_PLUS_STRUCTURE%TYPE

Line 7802: ,P_Cp_Structure PA_COST_PLUS_STRUCTURES.COST_PLUS_STRUCTURE%TYPE

7798: ,P_Cp_Structure IN PA_COST_PLUS_STRUCTURES.COST_PLUS_STRUCTURE%TYPE
7799: )
7800: IS
7801: CURSOR impacted_cost_bases_cur( P_Ind_Rate_Sch_Revision_Id PA_IND_RATE_SCH_REVISIONS.IND_RATE_SCH_REVISION_ID%TYPE
7802: ,P_Cp_Structure PA_COST_PLUS_STRUCTURES.COST_PLUS_STRUCTURE%TYPE
7803: )
7804: IS
7805: SELECT pcb.COST_BASE
7806: FROM PA_COST_BASES pcb