705: -- defaulting to Yes for these attributes when new revision is created
706: X_COPY_INIT_ACCOMPL_FLAG =>'Y',
707: X_COPY_DEFERRALS_FLAG =>'Y',
708: X_CREATION_DATE =>sysdate,
709: X_CREATED_BY =>fnd_global.user_id,
710: X_LAST_UPDATE_DATE =>sysdate,
711: X_LAST_UPDATED_BY =>fnd_global.user_id,
712: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
713: end loop;
707: X_COPY_DEFERRALS_FLAG =>'Y',
708: X_CREATION_DATE =>sysdate,
709: X_CREATED_BY =>fnd_global.user_id,
710: X_LAST_UPDATE_DATE =>sysdate,
711: X_LAST_UPDATED_BY =>fnd_global.user_id,
712: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
713: end loop;
714:
715:
708: X_CREATION_DATE =>sysdate,
709: X_CREATED_BY =>fnd_global.user_id,
710: X_LAST_UPDATE_DATE =>sysdate,
711: X_LAST_UPDATED_BY =>fnd_global.user_id,
712: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
713: end loop;
714:
715:
716: for l_association_rec in CurGetDocTitledet
753: X_FIGURE =>l_association_rec.figure,
754: X_PAGE =>l_association_rec.page,
755: X_NOTE =>l_association_rec.note,
756: X_CREATION_DATE =>sysdate,
757: X_CREATED_BY =>fnd_global.user_id,
758: X_LAST_UPDATE_DATE =>sysdate,
759: X_LAST_UPDATED_BY =>fnd_global.user_id,
760: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
761:
755: X_NOTE =>l_association_rec.note,
756: X_CREATION_DATE =>sysdate,
757: X_CREATED_BY =>fnd_global.user_id,
758: X_LAST_UPDATE_DATE =>sysdate,
759: X_LAST_UPDATED_BY =>fnd_global.user_id,
760: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
761:
762: end loop;
763:
756: X_CREATION_DATE =>sysdate,
757: X_CREATED_BY =>fnd_global.user_id,
758: X_LAST_UPDATE_DATE =>sysdate,
759: X_LAST_UPDATED_BY =>fnd_global.user_id,
760: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
761:
762: end loop;
763:
764: for l_mr_route_rec in CurGetRoutedet
789: X_ATTRIBUTE13 =>l_mr_route_Rec.ATTRIBUTE14,
790: X_ATTRIBUTE14 =>l_mr_route_Rec.ATTRIBUTE15,
791: X_ATTRIBUTE15 =>l_mr_route_Rec.ATTRIBUTE15,
792: X_CREATION_DATE =>sysdate,
793: X_CREATED_BY =>fnd_global.user_id,
794: X_LAST_UPDATE_DATE =>sysdate,
795: X_LAST_UPDATED_BY =>fnd_global.user_id,
796: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
797: L_MR_ROUTE_INDEX:=L_MR_ROUTE_INDEX+1;
791: X_ATTRIBUTE15 =>l_mr_route_Rec.ATTRIBUTE15,
792: X_CREATION_DATE =>sysdate,
793: X_CREATED_BY =>fnd_global.user_id,
794: X_LAST_UPDATE_DATE =>sysdate,
795: X_LAST_UPDATED_BY =>fnd_global.user_id,
796: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
797: L_MR_ROUTE_INDEX:=L_MR_ROUTE_INDEX+1;
798: l_temp_mr_route_tbl(L_MR_ROUTE_INDEX).OLD_MR_ROUTE_ID:=l_old_mr_route_id;
799: l_temp_mr_route_tbl(L_MR_ROUTE_INDEX).NEW_MR_ROUTE_ID:=l_new_mr_ROUTE_ID;
792: X_CREATION_DATE =>sysdate,
793: X_CREATED_BY =>fnd_global.user_id,
794: X_LAST_UPDATE_DATE =>sysdate,
795: X_LAST_UPDATED_BY =>fnd_global.user_id,
796: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
797: L_MR_ROUTE_INDEX:=L_MR_ROUTE_INDEX+1;
798: l_temp_mr_route_tbl(L_MR_ROUTE_INDEX).OLD_MR_ROUTE_ID:=l_old_mr_route_id;
799: l_temp_mr_route_tbl(L_MR_ROUTE_INDEX).NEW_MR_ROUTE_ID:=l_new_mr_ROUTE_ID;
800: End loop;
845: X_ATTRIBUTE13 =>l_mr_route_seq_rec.ATTRIBUTE13,
846: X_ATTRIBUTE14 =>l_mr_route_seq_rec.ATTRIBUTE14,
847: X_ATTRIBUTE15 =>l_mr_route_seq_rec.ATTRIBUTE15,
848: X_CREATION_DATE =>sysdate,
849: X_CREATED_BY =>fnd_global.user_id,
850: X_LAST_UPDATE_DATE =>sysdate,
851: X_LAST_UPDATED_BY =>fnd_global.user_id,
852: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
853: end loop;
847: X_ATTRIBUTE15 =>l_mr_route_seq_rec.ATTRIBUTE15,
848: X_CREATION_DATE =>sysdate,
849: X_CREATED_BY =>fnd_global.user_id,
850: X_LAST_UPDATE_DATE =>sysdate,
851: X_LAST_UPDATED_BY =>fnd_global.user_id,
852: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
853: end loop;
854: CLOSE CurGetRouteSeqDet;
855:
848: X_CREATION_DATE =>sysdate,
849: X_CREATED_BY =>fnd_global.user_id,
850: X_LAST_UPDATE_DATE =>sysdate,
851: X_LAST_UPDATED_BY =>fnd_global.user_id,
852: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
853: end loop;
854: CLOSE CurGetRouteSeqDet;
855:
856: END LOOP;
896: (
897: AHL_MR_EFFECTIVITIES_S.NEXTVAL,
898: 1,
899: SYSDATE,
900: fnd_global.user_id,
901: SYSDATE,
902: fnd_global.user_id,
903: fnd_global.user_id,
904: x_new_mr_header_id,
898: 1,
899: SYSDATE,
900: fnd_global.user_id,
901: SYSDATE,
902: fnd_global.user_id,
903: fnd_global.user_id,
904: x_new_mr_header_id,
905: l_mr_eff_rec.NAME,
906: l_mr_eff_rec.THRESHOLD_DATE,
899: SYSDATE,
900: fnd_global.user_id,
901: SYSDATE,
902: fnd_global.user_id,
903: fnd_global.user_id,
904: x_new_mr_header_id,
905: l_mr_eff_rec.NAME,
906: l_mr_eff_rec.THRESHOLD_DATE,
907: l_mr_eff_rec.INVENTORY_ITEM_ID,
977: (
978: AHL_MR_INTERVALS_S.NEXTVAL,
979: l_interval_rec.OBJECT_VERSION_NUMBER,
980: sysdate,
981: fnd_global.user_id,
982: sysdate,
983: fnd_global.user_id,
984: fnd_global.user_id,
985: l_new_mr_effectivity_id,
979: l_interval_rec.OBJECT_VERSION_NUMBER,
980: sysdate,
981: fnd_global.user_id,
982: sysdate,
983: fnd_global.user_id,
984: fnd_global.user_id,
985: l_new_mr_effectivity_id,
986: l_interval_rec.COUNTER_ID,
987: l_interval_rec.INTERVAL_VALUE,
980: sysdate,
981: fnd_global.user_id,
982: sysdate,
983: fnd_global.user_id,
984: fnd_global.user_id,
985: l_new_mr_effectivity_id,
986: l_interval_rec.COUNTER_ID,
987: l_interval_rec.INTERVAL_VALUE,
988: l_interval_rec.EARLIEST_DUE_VALUE,
1071: l_mr_effect_dtls_rec.MANUFACTURE_DATE_FROM,
1072: l_mr_effect_dtls_rec.MANUFACTURE_DATE_TO,
1073: 1,
1074: SYSDATE,
1075: fnd_global.user_id,
1076: SYSDATE,
1077: fnd_global.user_id,
1078: fnd_global.user_id,
1079: l_mr_effect_dtls_rec.ATTRIBUTE_CATEGORY,
1073: 1,
1074: SYSDATE,
1075: fnd_global.user_id,
1076: SYSDATE,
1077: fnd_global.user_id,
1078: fnd_global.user_id,
1079: l_mr_effect_dtls_rec.ATTRIBUTE_CATEGORY,
1080: l_mr_effect_dtls_rec.ATTRIBUTE1,
1081: l_mr_effect_dtls_rec.ATTRIBUTE2,
1074: SYSDATE,
1075: fnd_global.user_id,
1076: SYSDATE,
1077: fnd_global.user_id,
1078: fnd_global.user_id,
1079: l_mr_effect_dtls_rec.ATTRIBUTE_CATEGORY,
1080: l_mr_effect_dtls_rec.ATTRIBUTE1,
1081: l_mr_effect_dtls_rec.ATTRIBUTE2,
1082: l_mr_effect_dtls_rec.ATTRIBUTE3,
1144: values(
1145: AHL_MR_RELATIONSHIPS_S.NEXTVAL,
1146: 1,
1147: SYSDATE,
1148: fnd_global.user_id,
1149: SYSDATE,
1150: fnd_global.user_id,
1151: fnd_global.user_id,
1152: l_rel_Rec.MR_HEADER_ID,
1146: 1,
1147: SYSDATE,
1148: fnd_global.user_id,
1149: SYSDATE,
1150: fnd_global.user_id,
1151: fnd_global.user_id,
1152: l_rel_Rec.MR_HEADER_ID,
1153: l_rel_Rec.RELATED_MR_HEADER_ID,
1154: l_mr_relation_Rec.RELATIONSHIP_CODE,
1147: SYSDATE,
1148: fnd_global.user_id,
1149: SYSDATE,
1150: fnd_global.user_id,
1151: fnd_global.user_id,
1152: l_rel_Rec.MR_HEADER_ID,
1153: l_rel_Rec.RELATED_MR_HEADER_ID,
1154: l_mr_relation_Rec.RELATIONSHIP_CODE,
1155: l_mr_relation_Rec.ATTRIBUTE_CATEGORY,
1206: (
1207: AHL_MR_VISIT_TYPES_S.NEXTVAL,
1208: 1,
1209: SYSDATE,
1210: fnd_global.user_id,
1211: SYSDATE,
1212: fnd_global.user_id,
1213: fnd_global.user_id,
1214: x_new_MR_HEADER_ID,
1208: 1,
1209: SYSDATE,
1210: fnd_global.user_id,
1211: SYSDATE,
1212: fnd_global.user_id,
1213: fnd_global.user_id,
1214: x_new_MR_HEADER_ID,
1215: l_mrvisttype_rec.SECURITY_GROUP_ID,
1216: l_mrvisttype_rec.ATTRIBUTE_CATEGORY,
1209: SYSDATE,
1210: fnd_global.user_id,
1211: SYSDATE,
1212: fnd_global.user_id,
1213: fnd_global.user_id,
1214: x_new_MR_HEADER_ID,
1215: l_mrvisttype_rec.SECURITY_GROUP_ID,
1216: l_mrvisttype_rec.ATTRIBUTE_CATEGORY,
1217: l_mrvisttype_rec.ATTRIBUTE1,
1639: P_ORIG_STATUS_CODE =>'ACTIVE',
1640: -- P_NEW_STATUS_CODE =>'APPROVED',
1641: P_NEW_STATUS_CODE => l_approved_status_code,
1642: P_REJECT_STATUS_CODE =>'REJECTED',
1643: P_REQUESTER_USERID =>fnd_global.user_id,
1644: P_NOTES_FROM_REQUESTER =>'',
1645: P_WORKFLOWPROCESS =>'AHL_GEN_APPROVAL',
1646: P_ITEM_TYPE =>'AHLGAPP',
1647: p_application_usg_code =>G_APPLN_USAGE