APPS.GMLCOPPR dependencies on OP_PRCE_EFF

Line 1060: PROCEDURE copy_effectivity( p_old_priceff_id IN OP_PRCE_EFF.PRICEFF_ID%TYPE ,

1056: | user defined: Procedure specific : -30040 to -30049 |
1057: | |
1058: +========================================================================*/
1059:
1060: PROCEDURE copy_effectivity( p_old_priceff_id IN OP_PRCE_EFF.PRICEFF_ID%TYPE ,
1061: p_list_id IN OP_PRCE_EFF.PRICELIST_ID%TYPE ,
1062: p_new_start_date IN OP_PRCE_EFF.START_DATE%TYPE ,
1063: p_new_end_date IN OP_PRCE_EFF.END_DATE%TYPE ,
1064: p_new_preference IN OP_PRCE_EFF.PREFERENCE%TYPE ,

Line 1061: p_list_id IN OP_PRCE_EFF.PRICELIST_ID%TYPE ,

1057: | |
1058: +========================================================================*/
1059:
1060: PROCEDURE copy_effectivity( p_old_priceff_id IN OP_PRCE_EFF.PRICEFF_ID%TYPE ,
1061: p_list_id IN OP_PRCE_EFF.PRICELIST_ID%TYPE ,
1062: p_new_start_date IN OP_PRCE_EFF.START_DATE%TYPE ,
1063: p_new_end_date IN OP_PRCE_EFF.END_DATE%TYPE ,
1064: p_new_preference IN OP_PRCE_EFF.PREFERENCE%TYPE ,
1065: p_copy_text IN VARCHAR2 ,

Line 1062: p_new_start_date IN OP_PRCE_EFF.START_DATE%TYPE ,

1058: +========================================================================*/
1059:
1060: PROCEDURE copy_effectivity( p_old_priceff_id IN OP_PRCE_EFF.PRICEFF_ID%TYPE ,
1061: p_list_id IN OP_PRCE_EFF.PRICELIST_ID%TYPE ,
1062: p_new_start_date IN OP_PRCE_EFF.START_DATE%TYPE ,
1063: p_new_end_date IN OP_PRCE_EFF.END_DATE%TYPE ,
1064: p_new_preference IN OP_PRCE_EFF.PREFERENCE%TYPE ,
1065: p_copy_text IN VARCHAR2 ,
1066: p_user_id IN OP_PRCE_EFF.CREATED_BY%TYPE ,

Line 1063: p_new_end_date IN OP_PRCE_EFF.END_DATE%TYPE ,

1059:
1060: PROCEDURE copy_effectivity( p_old_priceff_id IN OP_PRCE_EFF.PRICEFF_ID%TYPE ,
1061: p_list_id IN OP_PRCE_EFF.PRICELIST_ID%TYPE ,
1062: p_new_start_date IN OP_PRCE_EFF.START_DATE%TYPE ,
1063: p_new_end_date IN OP_PRCE_EFF.END_DATE%TYPE ,
1064: p_new_preference IN OP_PRCE_EFF.PREFERENCE%TYPE ,
1065: p_copy_text IN VARCHAR2 ,
1066: p_user_id IN OP_PRCE_EFF.CREATED_BY%TYPE ,
1067: p_err_num OUT NOCOPY NUMBER ,

Line 1064: p_new_preference IN OP_PRCE_EFF.PREFERENCE%TYPE ,

1060: PROCEDURE copy_effectivity( p_old_priceff_id IN OP_PRCE_EFF.PRICEFF_ID%TYPE ,
1061: p_list_id IN OP_PRCE_EFF.PRICELIST_ID%TYPE ,
1062: p_new_start_date IN OP_PRCE_EFF.START_DATE%TYPE ,
1063: p_new_end_date IN OP_PRCE_EFF.END_DATE%TYPE ,
1064: p_new_preference IN OP_PRCE_EFF.PREFERENCE%TYPE ,
1065: p_copy_text IN VARCHAR2 ,
1066: p_user_id IN OP_PRCE_EFF.CREATED_BY%TYPE ,
1067: p_err_num OUT NOCOPY NUMBER ,
1068: p_err_msg OUT NOCOPY VARCHAR2

Line 1066: p_user_id IN OP_PRCE_EFF.CREATED_BY%TYPE ,

1062: p_new_start_date IN OP_PRCE_EFF.START_DATE%TYPE ,
1063: p_new_end_date IN OP_PRCE_EFF.END_DATE%TYPE ,
1064: p_new_preference IN OP_PRCE_EFF.PREFERENCE%TYPE ,
1065: p_copy_text IN VARCHAR2 ,
1066: p_user_id IN OP_PRCE_EFF.CREATED_BY%TYPE ,
1067: p_err_num OUT NOCOPY NUMBER ,
1068: p_err_msg OUT NOCOPY VARCHAR2
1069: ) IS
1070:

Line 1075: FROM op_prce_eff

1071: /* Cursors */
1072: /* Effectivity record. */
1073: CURSOR Cur_prce_eff IS
1074: SELECT *
1075: FROM op_prce_eff
1076: WHERE priceff_id = p_old_priceff_id ;
1077:
1078: /* Charge type */
1079: CURSOR Cur_linecharge_ind IS

Line 1091: FROM op_prce_eff

1087:
1088: /* Overlapping dates with duplicate effectivity -Pricelist. */
1089: CURSOR Cur_check_dup_eff IS
1090: SELECT COUNT(1)
1091: FROM op_prce_eff
1092: WHERE ( ( orgn_code = v_prce_eff.orgn_code)
1093: OR ( orgn_code IS NULL AND v_prce_eff.orgn_code IS NULL ) )
1094: AND ( ( custprice_class = v_prce_eff.custprice_class )
1095: OR ( custprice_class IS NULL AND v_prce_eff.custprice_class IS NULL ) )

Line 1108: X_priceff_id OP_PRCE_EFF.PRICEFF_ID%TYPE ;

1104: );
1105:
1106:
1107: /* Scalars */
1108: X_priceff_id OP_PRCE_EFF.PRICEFF_ID%TYPE ;
1109: X_prce_eff_text_code OP_PRCE_EFF.TEXT_CODE%TYPE ;
1110: X_linecharge_ind OP_CHRG_MST.LINECHARGE_IND%TYPE ;
1111: X_check_dup_eff NUMBER DEFAULT 0 ;
1112:

Line 1109: X_prce_eff_text_code OP_PRCE_EFF.TEXT_CODE%TYPE ;

1105:
1106:
1107: /* Scalars */
1108: X_priceff_id OP_PRCE_EFF.PRICEFF_ID%TYPE ;
1109: X_prce_eff_text_code OP_PRCE_EFF.TEXT_CODE%TYPE ;
1110: X_linecharge_ind OP_CHRG_MST.LINECHARGE_IND%TYPE ;
1111: X_check_dup_eff NUMBER DEFAULT 0 ;
1112:
1113: /* Exceptions */

Line 1177: /* Now write the OP_PRCE_EFF record to the table. */

1173: ELSE
1174: X_prce_eff_text_code := NULL;
1175: END IF;
1176:
1177: /* Now write the OP_PRCE_EFF record to the table. */
1178: INSERT INTO OP_PRCE_EFF(PRICEFF_ID ,
1179: ORGN_CODE ,
1180: PROMOTION_ID ,
1181: CUST_ID ,

Line 1178: INSERT INTO OP_PRCE_EFF(PRICEFF_ID ,

1174: X_prce_eff_text_code := NULL;
1175: END IF;
1176:
1177: /* Now write the OP_PRCE_EFF record to the table. */
1178: INSERT INTO OP_PRCE_EFF(PRICEFF_ID ,
1179: ORGN_CODE ,
1180: PROMOTION_ID ,
1181: CUST_ID ,
1182: INACTIVE_IND ,