71: FETCH C2 INTO X_Agreement_Id;
72: CLOSE C2;
73: end if;
74:
75: INSERT INTO PA_AGREEMENTS_ALL(
76: agreement_id,
77: customer_id,
78: agreement_num,
79: agreement_type,
478: l_char Varchar2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
479: l_date Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
480:
481: BEGIN
482: UPDATE PA_AGREEMENTS_ALL
483: SET
484: agreement_id = decode(X_Agreement_Id,l_num,agreement_id,X_Agreement_Id),
485: customer_id = decode(X_Customer_Id,l_num,customer_id,X_Customer_Id),
486: agreement_num = decode(X_Agreement_Num,l_char,agreement_num,X_Agreement_Num),